Python Pandas

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 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 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 output parameter type description file object output field file file string output field file file name string name of the resource 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 file string optional parameter for excel sheet names file name string optional name of the resource output parameter type description sheet names array name of the resource 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 file string optional parameter for excelfile file name string optional name of the resource input parameters object optional parameters for the excelfile action output parameter type description sheet names object name of the resource math array output field math name string name of the resource score number score value science array output field science name string name of the resource score number score value english array output field english name string name of the resource score number score value 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 file string optional parameter for excelfile book file name string optional name of the resource output parameter type description sheets data object response data math array output field math name string name of the resource score number score value science array output field science name string name of the resource score number score value english array output field english name string name of the resource score number score value total sheets number output field total sheets 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 output parameter type description file object output field file file string output field file file name string name of the resource 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 file string optional parameter for parse specific sheet file name string optional name of the resource sheet name string required the name of the sheet to be parsed from the excel file output parameter type description name object name of the resource 0 string output field 0 1 string output field 1 2 string output field 2 score object score value 0 number output field 0 1 number output field 1 2 number output field 2 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 file string optional parameter for read excel file file name string optional name of the resource file inputs object optional file inputs to be used in the action output parameter type description name object name of the resource 0 string output field 0 1 string output field 1 2 string output field 2 score object score value 0 number output field 0 1 number output field 1 2 number output field 2 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 file string optional parameter for styler to an excel 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 output parameter type description file object output field file file string output field file file name string name of the resource example \[ { "file" { "file" "string", "file name" "example name" } } ]