Python Excel Related

Conditional Search Multiple Excel Files

• conditionally search for values across multiple spreadsheets and return multiple values back when the conditional is true.
• Then combine the results into 1 excel file

How to Split an Excel File into multiple sheets or multiple files

• Filter data and put results in either multiple sheets or multiple files

Combine multiple excel files into One

• Go through a dir and combine multiple excel files

Merge files based on ID, then do calculation

• Merge 2 files based on id, then calculate total price by multiplying 2 columns. The create a pie chart

Merge Files based on primary key, and sort

• query two files based on primary key, sort results on various columns

Python, Excel Individual Commands

• Single commands such as: sorting pie charts opening excel files