w3resource

Pandas Datetime: Calculate all the sighting days of the unidentified flying object from current date

Pandas Datetime: Exercise-2 with Solution

Write a Pandas program to calculate all the sighting days of the unidentified flying object (ufo) from current date.

Sample Solution :

Python Code :

import pandas as pd
df = pd.read_csv(r'ufo.csv')
df['Date_time'] = df['Date_time'].astype('datetime64[ns]')
now = pd.to_datetime('today')
print("Original Dataframe:")
print(df.head())
print("\nCurrent date:")
print(now)

Sample Output:

Original Dataframe:
            Date_time                  city     ...       latitude   longitude
0 1910-06-01 15:00:00           wills point     ...      32.709167  -96.008056
1 1920-06-11 21:00:00                cicero     ...      40.123889  -86.013333
2 1929-07-05 14:00:00  buchanan  (or burns)     ...      43.642500 -118.627500
3 1931-06-01 13:00:00               abilene     ...      38.917222  -97.213611
4 1939-06-01 20:00:00              waterloo     ...      34.918056  -88.064167

[5 rows x 11 columns]

Current date:
2019-07-11 11:48:54.827800

Python Code Editor:


Have another way to solve this solution? Contribute your code (and comments) through Disqus.

Previous: Write a Pandas program to create the todays date.
Next: Write a Pandas program to get the current date, oldest date and number of days between Current date and oldest date of Ufo dataset.

What is the difficulty level of this exercise?



Inviting useful, relevant, well-written and unique guest posts