Python Excel Related - Revision history

Bacchas at 17:40, 24 March 2023

2023-03-24T17:40:35Z

← Older revision		Revision as of 17:40, 24 March 2023
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]]=

2020-09-11T21:32:55Z

← Older revision		Revision as of 21:32, 11 September 2020
Line 11:		Line 11:
	=[[Merge files based on ID, then do calculation]]=		=[[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 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]]=		=[[Python, Excel Individual Commands]]=
	* Single commands such as: sorting pie charts opening excel files		* Single commands such as: sorting pie charts opening excel files

2020-09-11T18:15:46Z

← Older revision		Revision as of 18:15, 11 September 2020
Line 11:		Line 11:
	=[[Merge files based on ID, then do calculation]]=		=[[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 2 files based on id, then calculate total price by multiplying 2 columns. The create a pie chart
			=[[Python, Excel Individual Commands]]=
			* Single commands such as: sorting pie charts opening excel files

2020-09-09T21:01:06Z

← Older revision		Revision as of 21:01, 9 September 2020
Line 9:		Line 9:
	=[[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

2020-09-03T15:52:05Z

Conditional Search Multiple Excel Files

← Older revision		Revision as of 15:52, 3 September 2020
Line 3:		Line 3:
	=[[Conditional Search Multiple Excel Files]]=		=[[Conditional Search Multiple Excel Files]]=
	* conditionally search for values across multiple spreadsheets and return multiple values back when the conditional is true.		* 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]]=		=[[How to Split an Excel File into multiple sheets or multiple files]]=
	* Filter data and put results in either multiple sheets or multiple files		* Filter data and put results in either multiple sheets or multiple files
	=[[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

2020-09-02T22:15:25Z

← Older revision		Revision as of 22:15, 2 September 2020
Line 5:		Line 5:
	=[[How to Split an Excel File into multiple sheets or multiple files]]=		=[[How to Split an Excel File into multiple sheets or multiple files]]=
	* Filter data and put results in either 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

2020-09-02T16:21:21Z

← Older revision		Revision as of 16:21, 2 September 2020
Line 3:		Line 3:
	=[[Conditional Search Multiple Excel Files]]=		=[[Conditional Search Multiple Excel Files]]=
	* conditionally search for values across multiple spreadsheets and return multiple values back when the conditional is true.		* conditionally search for values across multiple spreadsheets and return multiple values back when the conditional is true.
			=[[How to Split an Excel File into multiple sheets or multiple files]]=
			* Filter data and put results in either multiple sheets or multiple files

2020-09-01T18:19:26Z

Conditional Search Multiple Excel Files

← Older revision		Revision as of 18:19, 1 September 2020
Line 2:		Line 2:
	=[[Merge Excel Spreadsheet with same columns]]=		=[[Merge Excel Spreadsheet with same columns]]=
	=[[Conditional Search Multiple Excel Files]]=		=[[Conditional Search Multiple Excel Files]]=
	** conditionally search for values across multiple spreadsheets and return multiple values back when the conditional is true.		* conditionally search for values across multiple spreadsheets and return multiple values back when the conditional is true.

2020-09-01T18:19:18Z

← Older revision		Revision as of 18:19, 1 September 2020
Line 1:		Line 1:
	=[[Clean up excel data]]=		=[[Clean up excel data]]=
	=[[Merge Excel Spreadsheet with same columns]]=		=[[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.

2020-09-01T16:22:44Z

← Older revision		Revision as of 16:22, 1 September 2020
Line 1:		Line 1:
	=[[Clean up excel data]]=		=[[Clean up excel data]]=
			=[[Merge Excel Spreadsheet with same columns]]=