Jun-01-2021, 04:06 AM
Hi,
I tried 3 different ways to read csv data into python.
The 1st and 2nd methods turn data to dataframe and list, and they both work OK
The 3rd method, return something with:
type(dt): <class '_io.TextIOWrapper'>
print(dt): <_io.TextIOWrapper name='C:\\temp\\LongPctls.csv' mode='r' encoding='cp1252'>
Can you please help explain what form of data is that?
When I use for loop, I can still print out dt.
Thank you, Hong
I tried 3 different ways to read csv data into python.
The 1st and 2nd methods turn data to dataframe and list, and they both work OK
The 3rd method, return something with:
type(dt): <class '_io.TextIOWrapper'>
print(dt): <_io.TextIOWrapper name='C:\\temp\\LongPctls.csv' mode='r' encoding='cp1252'>
Can you please help explain what form of data is that?
When I use for loop, I can still print out dt.
Thank you, Hong
#Method 1: return dataframe file_name_csv="C:\\temp\LongPctls.csv" df=pd.read_csv(file_name_csv) print(type(df)) print(df) #Method 2: return list file = "C:\\temp\LongPctls.csv" data = open(file, "r") list = data.read().split('\n') print(list) print(type(list)) # Method 3: ????? with open("C:\\temp\LongPctls.csv", mode="r") as dt: print(type(dt)) print(dt) for i in dt: print(i)