Select rows in a dataframe by date

Question

For a given dataframe with a datetime column (2018-09-09 06:15:00), I would like to find all the rows that match a given date "2018-01-08".

I have tried something like this:

def get_connections(df, mydate):
    connections = df.loc[(df['dates']) == mydate]
    return connections

sushanth · Accepted Answer · 2020-08-20 16:57:33Z

2

Here is a solution,

import pandas as pd

df = pd.DataFrame({"dates":["2018-09-09 06:15:00", "2018-01-08 06:15:00"]})

df[pd.to_datetime(df.dates).dt.strftime("%Y-%m-%d").eq("2018-01-08")]

                 dates
1  2018-01-08 06:15:00

answered Aug 20, 2020 at 16:57

sushanth

8,2923 gold badges20 silver badges31 bronze badges

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

Comments

Kuldip Chaudhari · Accepted Answer · 2020-08-20 17:04:45Z

1

try this

from datetime as datetime as dt
df['dates'] = df['dates'].apply(dt.fromisoformat)

def get_connections(df, mydate):
    connections = df.loc[df['dates'].apply(dt.date) == dt.strptime(mydate, '%Y-%m-%d')]
    return connections
get_connections(datestring)

answered Aug 20, 2020 at 17:04

Kuldip Chaudhari

1,1146 silver badges8 bronze badges

Collectives™ on Stack Overflow

Select rows in a dataframe by date

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related