/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

0 vote98 views1 answer
Azure functions read only file system
Python
0 vote107 views1 answer
Search for a word in pdf using python
Python
0 vote96 views1 answer
"default_dburl" is not defined Pylance
Python
1 vote100 views1 answer
Ipython save session
Python
0 vote142 views1 answer
Whitelist the ip address django
Python Django
5 votes92 views3 answers
Print command python
Python
1 vote169 views2 answers
Django content type
Python Django
12 votes98 views6 answers
Remove rows from dataframe
Python
0 vote120 views2 answers
Completely uninstall python and all vritualenvs from mac
Python
6 votes102 views6 answers
Dict keys to list
Python