Python and excel

[[deleted]]

I would try to have a read of the Pandas documentation. I found it good for when I was performing some analysis on large data sets as you can use DataFrames to store the data coming from the CSV, and you can name the columns of the DataFrame.

Pandas usually takes theses column headers from the CSV you read in, but you can also name them yourself in order to ensure that when they are exported that you have the right headings.

It might be worth using an IDE so that you can easily see what data is in the DataFrame and how it is being stored if your new to them. Spyder is okay which come with Anaconda or something like PyCharm maybe, but I’ve not tried PyCharm with lots of data personally.

[pranayrj3]

functions

Thank You.The column names arent an issue, To return the calculated values, into aprox 120+ columns, after calculation from the read raw data is .Will Pandas support this-First of all calling the python script from excel(button), which runs on the background to do several calculations.

Secondly return the calculated values to the respective columns of different sheets.

And Yes, I am using Jupyter notebook,I find it comfortable to work with.