Difference between revisions of "Python Excel Related"

From rbachwiki
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