Python Excel Related

From rbachwiki
Jump to navigation Jump to search

Clean up excel data

Merge Excel Spreadsheet with same columns

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