Pandas Datetime: Create a plot of distribution of UFO observation time
Pandas Datetime: Exercise-20 with Solution
Write a Pandas program to create a plot of distribution of UFO (unidentified flying object) observation time.
Sample Solution:
Python Code:
import pandas as pd
import matplotlib.pyplot as plt
import seaborn as sns
df = pd.read_csv(r'ufo.csv')
df['duration_sec'] = (df['length_of_encounter_seconds'].astype(float))/60
s = df["duration_sec"].quantile(0.95)
temp = df['duration_sec']
temp = temp.sort_values()
temp = temp[temp < s]
plt.figure(figsize=(10, 8))
sns.distplot(temp)
plt.xlabel('Duration(min)', fontsize=20)
plt.ylabel("Frequency", fontsize=15)
plt.xticks(fontsize=12)
plt.title("-Distribution of UFO obervation time-", fontsize=20)
plt.show()
Sample Output:
C:\Users\User\Anaconda3\lib\site-packages\scipy\stats\stats.py:1713: FutureWarning: Using a non-tuple sequence for multidimensional indexing is deprecated; use `arr[tuple(seq)]` instead of `arr[seq]`. In the future this will be interpreted as an array index, `arr[np.array(seq)]`, which will result either in an error or a different result. return np.add.reduce(sorted[indexer] * weights, axis=axis) / sumval
Python Code Editor:
Have another way to solve this solution? Contribute your code (and comments) through Disqus.
Previous: Write a Pandas program to check the empty values of UFO (unidentified flying object) Dataframe.
Next: Write a Pandas program to create a graphical analysis of UFO (unidentified flying object) sighted by month.
What is the difficulty level of this exercise?
It will be nice if you may share this link in any developer community or anywhere else, from where other developers may find this content. Thanks.
https://w3resource.com/python-exercises/pandas/datetime/pandas-datetime-exercise-20.php
- Weekly Trends and Language Statistics
- Weekly Trends and Language Statistics