Pandas Datetime: Get all the sighting years of the unidentified flying object (ufo) and create the year as column

Last update on May 03 2025 13:05:15 (UTC/GMT +8 hours)

6. Extract UFO Sighting Years

Write a Pandas program to get all the sighting years of the unidentified flying object (ufo) and create the year as column.

Sample Solution :

Python Code :

import pandas as pd
df = pd.read_csv(r'ufo.csv')
df['Date_time'] = df['Date_time'].astype('datetime64[ns]')
print("Original Dataframe:")
print(df.head())
print("\nSighting years of the unidentified flying object:")
df["Year"] = df.Date_time.dt.year
print(df.head(10))

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]

Sighting years of the unidentified flying object:
            Date_time                     city  ...    longitude  Year
0 1910-06-01 15:00:00              wills point  ...   -96.008056  1910
1 1920-06-11 21:00:00                   cicero  ...   -86.013333  1920
2 1929-07-05 14:00:00     buchanan  (or burns)  ...  -118.627500  1929
3 1931-06-01 13:00:00                  abilene  ...   -97.213611  1931
4 1939-06-01 20:00:00                 waterloo  ...   -88.064167  1939
5 1939-07-07 02:00:00                   keokuk  ...   -91.384722  1939
6 1941-06-01 13:00:00  ludington (hamlin lake)  ...   -86.452500  1941
7 1942-06-01 22:30:00                hapeville  ...   -84.410278  1942
8 1944-01-01 12:00:00                san diego  ...  -117.156389  1944
9 1944-06-01 12:00:00               los alamos  ...  -106.306389  1944

[10 rows x 12 columns]

For more Practice: Solve these Related Problems:

Write a Pandas program to extract the year from each UFO sighting date and create a new 'Year' column.
Write a Pandas program to convert the UFO reporting dates into a Series of years and display the unique years.
Write a Pandas program to add a column to the UFO DataFrame that contains only the year of each sighting using pd.to_datetime().year.
Write a Pandas program to group the UFO dataset by the extracted year and display the count of sightings per year.

Go to:

Previous: Write a Pandas program to get all the sighting days of the unidentified flying object (ufo) between 1950-10-10 and 1960-10-10.
Next: Write a Pandas program to create a plot to present the number of unidentified flying object (UFO) reports per year.

Python Code Editor:

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