Reading data to python: turn into list or dataframe

[hhchenfx]

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

#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)