Excel using Python

Question

I'm new to Python and I'm trying to make a program that automate some daily Excel work.

I just want to copy data from a sheet to another using pandas but I got an error. Can anyone help?

import pandas as pd

File1 = pd.read_excel('FileName1.xlsx', sheet_name='Sheet1')
print(File1.columns)
print(File1['Date'][2])
File2 = pd.read_excel('FileName2.xlsx', sheet_name='Sheet2')
File1['Date'][0] = File2['Date'][0]

Here's the error:

SettingWithCopyWarning: 
A value is trying to be set on a copy of a slice from a DataFrame

probably this will be helpful: https://stackoverflow.com/questions/20625582/how-to-deal-with-settingwithcopywarning-in-pandas — Roshan Bagdiya, Aug 15 '18 at 13:26
I saw it before but I didn't understand at first, anyway thank you. — Moustafa, Aug 15 '18 at 13:36

score 1 · Answer 1 · answered Aug 15 '18 at 13:27

1

Your error is being thrown in the statement File1['Date'][0] = File2['Date'][0]. Pandas does not allow assignment using indexes like typical lists. Try using indexing with loc: File1.loc[0, 'Date'] = File2.loc[0, 'Date']

answered Aug 15 '18 at 13:27

Kevin K.

1,327
2
13
18

Would you please tell me how to save these changes? – Moustafa Aug 15 '18 at 13:46
You can use `pd.to_excel('FileName1.xlsx')` – Kevin K. Aug 15 '18 at 13:47
I've got an error : module pandas has no attribute 'to_excel' – Moustafa Aug 27 '18 at 10:13

Excel using Python

1 Answers1