Bacchas at 16:25, 2 September 2020

2020-09-02T16:25:16Z

← Older revision		Revision as of 16:25, 2 September 2020
Line 19:		Line 19:
	</pre>		</pre>

	==[[#top\|Back To Top]] - [[Python\|Category]]==		==[[#top\|Back To Top]] - [[Python\|Main Category]]/[[Python_Excel_Related\| Excel Category]]==
	[[Category:Python]]		[[Category:Python]]

Bacchas: Created page with "=Merge two spreadsheets= '''Merge two or more spreets from different files with similar columns, but choose which columns you want to include in the merge'''

 import pan..."

2020-09-01T16:25:22Z

Created page with "=Merge two spreadsheets= '''Merge two or more spreets from different files with similar columns, but choose which columns you want to include in the merge''' <pre> import pan..."

New page

=Merge two spreadsheets=
'''Merge two or more spreets from different files with similar columns, but choose which columns you want to include in the merge'''

<pre>
import pandas as pd
file1 = 'wall1.xlsx'
file2 = 'wall2.xlsx'

wall1 = pd.read_excel(file1)
wall2 = pd.read_excel(file2)

values1 = wall1[['SKU','ProductType','SA3']]
values2 = wall2[['SKU','ProductType','SA3']]

dataframes = [values1, values2]
join = pd.concat(dataframes)
join.to_excel("output.xlsx")

</pre>

==[[#top|Back To Top]] - [[Python|Category]]==
[[Category:Python]]

Merge Excel Spreadsheet with same columns - Revision history

Bacchas at 16:25, 2 September 2020

Bacchas: Created page with "=Merge two spreadsheets= '''Merge two or more spreets from different files with similar columns, but choose which columns you want to include in the merge'''
import pan..."