Plot dates with Pandas and Seaborn
Marcelo Lazaroni
I have a DataFrame where each row is an event and it has a column of datetime values specifying the date and time of the event.
I just want to plot the amount of events for each day and be able to specify the start and end date of the x axis. How can I do that?
Nickil Maveli
Consider a DF containing a single column having datetime values as shown:
df = pd.DataFrame(pd.date_range('1/1/2016', periods=10, freq='D'), columns=['Date'])
Concatenate a sample of the original DF with itself to create duplicated values(say, 5)
df_dups = pd.concat([df, df.sample(n=5, random_state=42)], ignore_index=True)
Compute it's unique counts by stacking it into a series object.
plotting_df = df_dups.stack().value_counts().reset_index(name='counts')
Scatter Plot:
As only numerical values are supported for both x and y axis as args for the built-in scatter plot method, we must call the plot_date function of matplotlib axes object to retain the dates as it is.
fig, ax = plt.subplots()
ax.plot_date(plotting_df['index'], plotting_df['counts'], fmt='.', color='k')
ax.set_ylim(0, plotting_df['counts'].values.max()+1)
fig.autofmt_xdate()
plt.xlabel('Date')
plt.ylabel('Counts')
plt.show()
Collected from the Internet
Please contact [email protected] to delete if infringement.
edited at
Related
Related Related
- 1
Plot pandas dates in matplotlib
- 2
pandas plot conditional values seaborn
- 3
Can Pandas plot a histogram of dates?
- 4
How to plot kernel density plot of dates in Pandas?
- 5
pandas scatter plot colors with three points and seaborn
- 6
Plot multiple columns of Pandas DataFrame using Seaborn
- 7
How to plot hexbin with dates in matplotlib and pandas?
- 8
How to plot hexbin with dates in matplotlib and pandas?
- 9
Converting pandas dataframe to numeric; seaborn can't plot
- 10
using pandas.DataFrame.melt() to plot data with seaborn
- 11
Having trouble with a Seaborn Plot from a multilevel Pandas Dataframe
- 12
How to draw a line using slope in Pandas and Seaborn scatter plot?
- 13
Exceedance (1-cdf) plot using seaborn and pandas
- 14
Show dates on seaborn heatmap
- 15
Seaborn plot is not showing
- 16
Plot on top of seaborn clustermap
- 17
add a label to a plot with seaborn
- 18
Saving plot from seaborn
- 19
Formatting a plot in Seaborn
- 20
Hexbin plot in PairGrid with Seaborn
- 21
Seaborn horizontal bar plot
- 22
seaborn plot from total
- 23
why there is blank plot of seaborn?
- 24
plot dates and values in python
- 25
How to rank plot in seaborn boxplot?
- 26
Discrete legend in seaborn heatmap plot
- 27
How to save a Seaborn plot into a file
- 28
Setting plot background colour in Seaborn
- 29
Creating a bar plot using Seaborn
Comments