Reading a particular row in csv file with Python

Question

How to read string row in python?

I got a football csv file.

https://www.football-data.co.uk/mmz4281/1920/F1.csv I would like to retrieve all the lines where there is the PS Germain.

import pandas as pd
df = pd.read_csv('F1.csv')
dh = df[['Date','HomeTeam','AwayTeam','FTHG','FTAG']]
dh.head()

What is the "PS Germain"? Is that a team name? – monkut Aug 20 '20 at 12:41 — monkut, Aug 20 '20 at 12:41
Yeah, it's a French soccer team. – maceo bs Aug 20 '20 at 12:42 — maceo bs, Aug 20 '20 at 12:42
Still learning myself, but is it in the data? – monkut Aug 20 '20 at 12:44 — monkut, Aug 20 '20 at 12:44
Yes it is a data in the Hometeam column. – maceo bs Aug 20 '20 at 12:47 — maceo bs, Aug 20 '20 at 12:47
@maceobs `dh[dh['HomeTeam'] == 'PS Germain']` – filbranden Aug 20 '20 at 12:54 — filbranden, Aug 20 '20 at 12:54

score 2 · Answer 1 · answered Aug 20 '20 at 12:57

You need to select rows from your Pandas DataFrame. You can use the following logic to select rows from Pandas DataFrame based on specific conditions:

df.loc[df['column name'] condition]

In pratice that means:

result = df.loc[df['HomeTeam'] == 'PS Germain']

You're getting the result with:

print(result)

Of course you can use more conditions and combine them.

score 1 · Accepted Answer · answered Aug 20 '20 at 13:01

'Paris SG' HomeTeam or AwayTeam:

import pandas as pd
df = pd.read_csv('F1.csv')
dh = df[['Date','HomeTeam','AwayTeam','FTHG','FTAG']]

index_list = dh[(dh['HomeTeam'] == 'Paris SG') | (dh['AwayTeam'] == 'Paris SG')].index.tolist()
dh_final = dh.iloc[index_list]

dh762 · Answer 3 · 2020-08-20T14:01:55.543

0

Filtering where Paris SG is in the HomeTeam column:

import pandas as pd

df = pd.read_csv('https://www.football-data.co.uk/mmz4281/1920/F1.csv')
df = df[df['HomeTeam'] == 'Paris SG']

edited Aug 20 '20 at 14:01

answered Aug 20 '20 at 12:52

dh762

2,259
4
25
44

score 0 · Answer 4 · answered Aug 20 '20 at 12:55

0

Try the below sample:

for ind in df.index:
  if(df['HomeTeam'][ind]=='PS Germain'):
    #Do the needfull

answered Aug 20 '20 at 12:55

Kokul Jose

1,384
2
14
26

I don't think it is optimal solution. Could you elaborate your answer? – 404pio Aug 20 '20 at 13:04

Reading a particular row in csv file with Python

4 Answers4