My project is based on the data i read from excel file, could someone help me is it good idea to read the file in a class method? Or what would be better solution?

CodePudding user response：

One of the way to read excel is as below. I prefer this because we can do further more data processing, manipulation and analysis easily using pandas library:

import pandas as pd
df = pd.read_excel('filename.xlsx')

There are many other ways as well.

CodePudding user response：

I assume that you want to work with something similar to excel. You've asked about the method of how to read excel files but I strongly recommend reading some articles about D-Tale. That tool is great in the case of EDA.

Here is a good point to start:

• https://www.analyticsvidhya.com/blog/2021/06/exploring-pandas-dataframe-with-d-tale/

You can find there a lot of useful tools.