Import csv files into a dataframe using PY excel python function (df = pd.read_csv)

Question

Can I import a csv file into a dataframe using a PY excel python function? Example PY = df = pd.read_csv(file_path+file_name, header=0). The idea is to storage the csv data in a dataframe directly without having to use power query to import the CSV file into excel and then loading the excel query table into the python dataframe. That would be more efficient and save space in the excel file too.

Answer 1

Hi Thiago,

Thank you for posting in Microsoft Community.

We understand you wanted to import your csv files into a data frame using the Excel Python function. It appears that this feature is currently not available in Python in Excel. Upon further research, it appears that there are third-party softwares that can grant you this option but not specifically for Python in Excel. Python in Excel is still in Preview and currently still developing.

Hopefully in the near future updates this feature will added. You can bring this to our developers teams attention by submitting a feedback - Get started with Python in Excel - Excel (microsoft.com)

Thank you for your understanding

Sincerely,

Leonardo_Y

Answer 2

Hi,

https://www.youtube.com/watch?v=qEwnlMBaLfc