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: stackoverflow.com/questions/20625582/… — Roshan Bagdiya
– Roshan Bagdiya, Commented Aug 15, 2018 at 13:26
I saw it before but I didn't understand at first, anyway thank you. — Moustafa
– Moustafa, Commented Aug 15, 2018 at 13:36

Kevin K. · Accepted Answer · 2018-08-15 13:27:28Z

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, 2018 at 13:27

Kevin K.

1,4272 gold badges15 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Moustafa Over a year ago

Would you please tell me how to save these changes?

Kevin K. Over a year ago

You can use pd.to_excel('FileName1.xlsx')

Moustafa Over a year ago

I've got an error : module pandas has no attribute 'to_excel'

Collectives™ on Stack Overflow

Excel using Python

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related