Python Pandas
43 min
the python pandas connector enables seamless integration of excel file manipulation and dataframe analysis within swimlane's automation workflows python pandas is a powerful data manipulation and analysis library for python, offering a diverse range of functionalities for handling structured data the python pandas connector for swimlane turbine allows users to seamlessly integrate these capabilities into their security workflows users can convert, analyze, and manipulate data from excel files within the swimlane platform, enhancing their ability to make data driven decisions and automate complex data processing tasks this integration empowers end users to leverage pandas' robust data analysis tools without the need for extensive programming knowledge, streamlining data related operations and boosting efficiency in security automation limitations none to date supported versions this python pandas connector uses the version pandas sdk additional docs 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 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 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 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 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 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 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 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 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 converts a specified dataframe into an excel file for data manipulation and analysis with 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 a list of sheet names from an excel file using python pandas, requiring the 'files' 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 converts excel sheets into manipulable python pandas dataframe objects for enhanced data analysis 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 imports all sheets from an excel file into a dictionary, with each sheet's name as a key, requiring 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 with python pandas, necessitating a 'dataframes' input for 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 converts a specified sheet from an excel file into a dictionary format using python pandas, requiring 'files' 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 converts an excel file into a dictionary format for data manipulation and analysis with 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 file provided as input 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