Loading CSV trouble

[DrinkinBeer]

Hi everyone,

I just started learning Python and having an issue with loading csv. I had it working yesterday. The goal is to load my CSV and eventually modify the data and save it as an excel file.

Visual Studio code is not showing an error, but it is not printing any of the CSV, here is the code. (Both my .py and .csv are in the same folder. Python Version 3.9.1, pandas and xlsxwriter installed w/ pip)

import pandas as pd
import xlsxwriter 
list = pd.read_csv('list.csv')
list.head()

buran write Jan-12-2021, 08:29 PM:
Please, use proper tags when post code, traceback, output, etc. This time I have added tags for you.
See BBcode help for more info.

[buran]

you need to print it. probably, when you say it worked - it was in interactive python shell. but don't use list as name - it's a built-in function

import pandas as pd
df = pd.read_csv('list.csv') # df as DataFrame
print(df.head())
df.to_excel('list.xlsx')

No need to import xlsxwriter unless you plan to use it directly.

[DrinkinBeer]

Thanks Buran, that worked