/Python/Pandas add value to excel column and save

Pandas add value to excel column and save

import pandas as pd;
df = pd.read_excel("./YourExcel.xlsx");
YourDataInAList = [12.34,17.56,12.45];
df = df.append({"ColumnName": YourDataInAList}, ignore_index=True)
df.to_excel("./YourNewExcel.xlsx",index=False);

Source: stackoverflow.com

Similar codes

122 votes305 views6 answers
Prompt python
Python
2 votes314 views2 answers
Big comments python
Python
0 vote308 views1 answer
Positive counter python
Python
4 votes326 views3 answers
Pandas df by row index
Python
1 vote312 views1 answer
How to def variable as false in python
Python
6 votes322 views5 answers
Python open folder in explorer
Python
2 votes351 views1 answer
Django EMAIL_BACKEND console
Python Django
0 vote304 views1 answer
Python playsound stop
Python
0 vote329 views1 answer
How to store a int value in django sessions
Python
0 vote373 views2 answers
Where should favicon.ico be placed in flask app
Python Flask