How to load data from csv into numpy array using pandas

Question

I want to load csv rows into a numpy array using pandas library. I can read the csv using pandas but havent found any function that allows reading row by row in csv file.

How do I read row by row from csv using pandas and put it into an array?

ex.

     Parch            Ticket      Fare        Cabin Embarked  
0        0         A/5 21171    7.2500          NaN        S  
1        0          PC 17599   71.2833          C85        C

I want to create a list of lists like this:

[
[0, "A/5", 21171, 7.2500, NaN, "S"],
[0, "PC", 17599, 71.2833, "C85", "C"]
]

jezrael · Accepted Answer · 2016-10-25 11:35:26Z

3

First convert to numpy array by values and then ndarray.tolist:

print (df.values)
[[0 'A/5 21171' 7.25 nan 'S']
 [0 'PC 17599' 71.2833 'C85' 'C']]

print (df.values.tolist())
[[0, 'A/5 21171', 7.25, nan, 'S'], [0, 'PC 17599', 71.2833, 'C85', 'C']]

edited Oct 25, 2016 at 11:35

answered Oct 25, 2016 at 11:33

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to load data from csv into numpy array using pandas

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related