Panda.Read_CSV Usecols not print output as a list in Python 3.9

Question

Why when I am trying to print the following code...

import pandas
import csv

passengersid=pandas.read_csv('test.csv', usecols=['PassengerId'])

print(passengersid)

...I am getting this: Output

I am trying to get a simple list of values (without indexes of values and not a table) from the first (PassengersID) column in one csv file and then iterate and use it in the other csv file along with other data.

Answer 1

You are reading a data frame with the read_csv command.

col_one_list = passengersid['PassengerId'].tolist()

col_one_arr = passengersid['PassengerId'].to_numpy()

this will give you a list or an array as you need