Python Pandas
pandas is a python library that enables fast, flexible, and expressive data analysis and manipulation of structured data python pandas is a leading open source data analysis and manipulation library, widely used for transforming and processing structured data this connector enables swimlane turbine users to seamlessly read, write, and transform excel files and dataframes within automated workflowsβwithout writing code with robust actions for converting between excel and dataframe formats, extracting sheet names, and applying advanced formatting, users can automate complex data handling tasks directly in their security playbooks integrating python pandas with swimlane turbine empowers security teams to streamline data enrichment, reporting, and analysis, accelerating decision making and operational efficiency limitations none to date supported versions this python pandas connector uses the version pandas sdk additional docs api documentation https //pandas pydata org/docs/reference/io html#excel configuration prerequisites authentication is not required capabilities this connector provides the following capabilities dataframe to excel excel sheet names excelfile excelfile book excelwriter parse specific sheet read excel file styler to an excel dataframe to excel converts a dataframe into an excel file, allowing data manipulation and analysis within python pandas click here https //pandas pydata org/docs/reference/api/pandas dataframe to excel html#pandas dataframe to excel excel sheet names retrieve a list of sheet names from the specified excel file using python pandas click here https //pandas pydata org/docs/reference/api/pandas excelfile sheet names html#pandas excelfile sheet names excelfile parse tabular excel sheets into dataframe objects for data manipulation and analysis using python pandas click here https //pandas pydata org/docs/reference/api/pandas excelfile html#pandas excelfile excelfile book imports all sheets from an excel file into a dictionary with sheet names as keys, requiring the 'files' input click here https //pandas pydata org/docs/reference/api/pandas excelfile book html#pandas excelfile book excelwriter write dataframe objects into excel sheets using python pandas, requiring a 'dataframes' input click here https //pandas pydata org/docs/reference/api/pandas excelwriter html#pandas excelwriter parse specific sheet converts a specified sheet from an excel file into a dictionary format using python pandas click here https //pandas pydata org/docs/reference/api/pandas excelfile parse html#pandas excelfile parse read excel file converts an excel file into a dictionary format for data manipulation and analysis using python pandas click here https //pandas pydata org/docs/reference/api/pandas read excel html#pandas read excel styler to an excel write a pandas styler object to an excel sheet, requiring a specified file as input click here https //pandas pydata org/docs/reference/api/pandas io formats style styler to excel html#pandas io formats style styler to excel actions dataframe to excel convert a specified dataframe into an excel file for easy data manipulation and analysis using python pandas endpoint method get input argument name type required description dataframe object required dataframe to be written to the excel file input parameters object optional parameters for the excel file input example {"dataframe" {},"input parameters" {}} output parameter type description file object output field file file file string output field file file file file name string name of the resource output example {"file" {"file" "string","file name" "example name"}} excel sheet names retrieve all sheet names from an uploaded excel file using python pandas by providing the required file input endpoint method get input argument name type required description files object required retrieve a list of sheet names from the specified excel file using python pandas files file string optional parameter for excel sheet names files file name string optional name of the resource input example {"files" {"file" "string","file name" "example name"}} output parameter type description sheet names array name of the resource output example {"sheet names" \["math","science","english"]} excelfile convert excel files into python pandas dataframe objects for streamlined data analysis and manipulation endpoint method post input argument name type required description files object required parse tabular excel sheets into dataframe objects for data manipulation and analysis using python pandas files file string optional parameter for excelfile files file name string optional name of the resource input parameters object optional parameters for the excelfile action input example {"files" {"file" "string","file name" "example name"},"input parameters" {}} output parameter type description sheet names object name of the resource sheet names math array name of the resource sheet names math name string name of the resource sheet names math score number name of the resource sheet names science array name of the resource sheet names science name string name of the resource sheet names science score number name of the resource sheet names english array name of the resource sheet names english name string name of the resource sheet names english score number name of the resource output example {"sheet names" {"math" \[{},{},{}],"science" \[{},{},{}],"english" \[{},{},{}]}} excelfile book import all sheets from an excel file into a dictionary, using each sheet's name as the key requires the 'files' input endpoint method get input argument name type required description files object required imports all sheets from an excel file into a dictionary with sheet names as keys, requiring the file input files file string optional parameter for excelfile book files file name string optional name of the resource input example {"files" {"file" "string","file name" "example name"}} output parameter type description sheets data object response data sheets data math array response data sheets data math name string response data sheets data math score number response data sheets data science array response data sheets data science name string response data sheets data science score number response data sheets data english array response data sheets data english name string response data sheets data english score number response data total sheets number output field total sheets output example {"sheets data" {"math" \[{},{},{}],"science" \[{},{},{}],"english" \[{},{},{}]},"total sheets" 3} excelwriter write dataframe objects to excel sheets using python pandas, requiring a 'dataframes' input for successful operation endpoint method post input argument name type required description dataframes array required list of dataframes to be written to the excel file input parameters object optional parameters for the excel file input example {"dataframes" \[],"input parameters" {}} output parameter type description file object output field file file file string output field file file file file name string name of the resource output example {"file" {"file" "string","file name" "example name"}} parse specific sheet convert a specified sheet from an uploaded excel file into a dictionary format using python pandas by providing the file and sheet name endpoint method get input argument name type required description files object required converts a specified sheet from an excel file into a dictionary format using python pandas files file string optional parameter for parse specific sheet files file name string optional name of the resource sheet name string required the name of the sheet to be parsed from the excel file input example {"sheet name" "math"} output parameter type description name object name of the resource name 0 string name of the resource name 1 string name of the resource name 2 string name of the resource score object score value score 0 number output field score 0 score 1 number output field score 1 score 2 number output field score 2 output example {"name" {"0" "alice","1" "bob","2" "charlie"},"score" {"0" 95,"1" 88,"2" 72}} read excel file convert an excel file into a dictionary format for data manipulation and analysis using python pandas, requiring the 'files' input endpoint method get input argument name type required description files object required converts a specified sheet from an excel file into a dictionary format using python pandas files file string optional parameter for read excel file files file name string optional name of the resource file inputs object optional file inputs to be used in the action input example {"files" {"file" "string","file name" "example name"},"file inputs" {}} output parameter type description name object name of the resource name 0 string name of the resource name 1 string name of the resource name 2 string name of the resource score object score value score 0 number output field score 0 score 1 number output field score 1 score 2 number output field score 2 output example {"name" {"0" "alice","1" "bob","2" "charlie"},"score" {"0" 95,"1" 88,"2" 72}} styler to an excel write a pandas styler object to an excel sheet using the specified input file endpoint method get input argument name type required description newdataframe object optional new sheet to be created in the excel file files object required existing excel file to be modified files file string optional parameter for styler to an excel files file name string optional name of the resource sheet inputs 1 object optional inputs for the any one of existing sheet sheet inputs 2 object optional inputs for the new sheet input example {"newdataframe" {},"files" {"file" "string","file name" "example name"},"sheet inputs 1" {},"sheet inputs 2" {}} output parameter type description file object output field file file file string output field file file file file name string name of the resource output example {"file" {"file" "string","file name" "example name"}} response headers header description example content type the media type of the resource application/json date the date and time at which the message was originated thu, 01 jan 2024 00 00 00 gmt