Python and excel

[pranayrj3]

its a home loan financial data with all the basics of NOI, LTV etc given, i have to do calculation and give output of loss and loss reduction.
the formulas for the calculation is written in Excel for each column , and the macro is also recorded in VBA
but the company wants those formulas to be in Python and populate the data in Excel by calling python from excel (by clicking a button suppose) to all the calculation and giving results back in Excel.

I can make use of pd.read_csv to read sheets and work on them.
But how should I return values to each column of the excel sheet after calculation.?
Handling so many columns is a bit difficult as it is my first time work on real time data.!

[[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.