Sorry, I don't know much about pandas and what I want to achieve now is to add a row to my excel file (xlsx), I have tried the pandas method append
but it doesn't add
fileEst = pd.read_excel('mate2.xlsx)
fileEst .append(
pd.Series(['holaaaaas']),
ignore_index=True
)
How can I add a row?
I would recommend that instead of using
pandas
the library calledopenpyxl
.To be able to use it, you first have to install it
pip
from the terminal, with the following command:After doing that, you will be able to work with it in any script. I leave you an example code that writes information in the cells of an excel and at the end saves it with the name and path that you want:
The output is as seen below:
Cheers!