/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 vote178 views1 answer
Python pandas convert series to percent
Python
0 vote157 views1 answer
Best way to access nested key in python
Python
0 vote161 views1 answer
How to split a string with newline in python
Python
0 vote172 views1 answer
How to increase size of graph in jupyter
Python
10 votes154 views3 answers
Dataframein python
Python
0 vote171 views1 answer
Python convert xml to dictionary
Python
1 vote170 views2 answers
Python conditional operator one line
Python
0 vote163 views1 answer
Text adventure in python
Python
0 vote191 views1 answer
Reading a list in python
Python
0 vote172 views1 answer
Python list of list to list of string
Python