Difference between revisions of "Python Excel Related"
Jump to navigation
Jump to search
| (3 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
=[[Rename files using excel as source template]]= | |||
=[[Clean up excel data]]= | =[[Clean up excel data]]= | ||
=[[Merge Excel Spreadsheet with same columns]]= | =[[Merge Excel Spreadsheet with same columns]]= | ||
| Line 9: | Line 10: | ||
=[[Combine multiple excel files into One]]= | =[[Combine multiple excel files into One]]= | ||
* Go through a dir and combine multiple excel files | * 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 | |||
Latest revision as of 17:40, 24 March 2023
Rename files using excel as source template
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