I’m trying to print first name, last name and birthday, so how i could do it?
Here’s my code:
import pandas as pd import numpy as np from datetime import datetime, date pd.set_option('display.max_rows', None) pd.set_option('display.max_columns', None) pd.set_option('display.width', None) pd.set_option('display.max_colwidth', -1) df = pd.read_csv("legislators-current.csv") df.shape oldest = df['birthday'].min() print(oldest)
Output should be like this:
last_name | first_name | birthday |
---|---|---|
Cawthorn | David | 1995-08-01 |
Advertisement
Answer
First add parse_dates
to read_csv
for datetimes:
df = pd.read_csv("legislators-current.csv", parse_dates=['birthday'])
Then if need filter by minimal birthday
and columns in list use DataFrame.loc
:
df.loc[df['birthday'].eq(df['birthday'].min()), ['last_name','first_name','birthday']]
For all columns use boolean indexing
:
df[df['birthday'].eq(df['birthday'].min())]