Pandas - select rows

Question

Pandas - select rows

Navigation

#1 by (4 votes)

2

Hello.

How do I select a specific row in a dataframe?

df1=pd.read_csv('arquivo1.csv', encoding='ISO-8859-1', sep=";")

I have tried to df.index[2] , but it gives error. The 2 is the line I want.

python pandas

asked by anonymous 02.11.2017 / 18:05

1 answer

SQL Reporting Services: Problems with Arrows in the Chart Form behind the Windows toolbar

score 4 · Accepted Answer

Use the loc property.

For example, for the following CSV:

Year;Make;Model;Description;Price
1997;Ford;E350;"ac, abs, moon";3000.00
1999;Chevy;"Venture ""Extended Edition""";"";4900.00
1999;Chevy;"Venture ""Extended Edition; Very Large""";;5000.00
1996;Jeep;Grand Cherokee;"MUST SELL!
air, moon roof, loaded";4799.00

The following code prints the entire contents and then only the third line (index 2):

import pandas as pd

df1 = pd.read_csv('teste.csv', encoding='ISO-8859-1', sep=";")
print('Tudo:\n', df1)

lin = df1.loc[2]
print('Linha 3:\n', lin)

Result:

>teste.py
Tudo:
    Year   Make                                   Model  \
0  1997   Ford                                    E350
1  1999  Chevy              Venture "Extended Edition"
2  1999  Chevy  Venture "Extended Edition; Very Large"
3  1996   Jeep                          Grand Cherokee

                            Description   Price
0                         ac, abs, moon  3000.0
1                                   NaN  4900.0
2                                   NaN  5000.0
3  MUST SELL!\r\nair, moon roof, loaded  4799.0
Linha 3:
 Year                                             1999
Make                                            Chevy
Model          Venture "Extended Edition; Very Large"
Description                                       NaN
Price                                            5000
Name: 2, dtype: object

Sample CSV source: Wikipedia .