Subset time series data
When plotting time series data, you may occasionally want to visualize only a subset of the data. The pandas
library provides powerful indexing and subsetting methods that allow you to extract specific portions of a DataFrame. For example, you can subset all the data between 1950 and 1960 in the discoveries
DataFrame by specifying the following date range:
subset_data = discoveries['1950-01-01':'1960-01-01']
Note: Subsetting your data this way is only possible if the index of your DataFrame contains dates of the datetime
type. Failing that, the pandas
library will return an error message.
This exercise is part of the course
Visualizing Time Series Data in Python
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
# Select the subset of data between 1945 and 1950
discoveries_subset_1 = discoveries['____':'____']
# Plot the time series in your DataFrame as a blue area chart
ax = discoveries_subset_1.____(color='blue', fontsize=15)
# Show plot
plt.show()