Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR PYTHON

Convert string to datetime python

 Load libraries
import pandas as pd
from datetime import timedelta

# Loading dataset and creating duration column
url = 'https://drive.google.com/uc?id=1YV5bKobzYxVAWyB7VlxNH6dmfP4tHBui'
df = pd.read_csv(url, parse_dates = ['pickup_datetime', 'dropoff_datetime', 'dropoff_calculated'])
df["duration"] = pd.to_timedelta(df["duration"])

# Task 1 - filter to only rides with negative durations
df_neg = df[___["___"] < ___(___)]

# Task 2 - iterate over df_neg rows to find inconsistencies
count = 0
for i, row in df_neg.___():
  # Compare minutes of dropoff_datetime and dropoff_calculated
  if row["___"].___ != row["___"].minute:
    # Print these two columns
    print(___[["dropoff_datetime", "dropoff_calculated"]])
    # Task 3 - count number of rows having hour greater-equal than 12
  if row["___"].___ >= ___:
    count ___

print(f"There are {count} rows in df_neg having hour greater-equal than 12.")


Source by www.machinelearningplus.com #
 
PREVIOUS NEXT
Tagged: #Convert #string #datetime #python
ADD COMMENT
Topic
Name
6+3 =