An additional line in timeseries plot with Matplotlib

Question

I have a dataset of traffic flow for different stations.

I am trying to plot them only for a limited time like summer. When I plot, I can see there is a line crossing all the plot in each of them.

fig, ax = plt.subplots(nrows=16, figsize=(60,120))

stations = countData19_gdf['address'].unique()
print(len(stations))
summersubset = countData19_gdf.loc['2019-06-01': '2019-08-31']
cnt=0
for station in stations:
    station_data = summersubset[summersubset['address'] == station]
    ax[cnt].plot( station_data['volume'], c='green',  label= 'flow')
    ax[cnt].title.set_text(station)
    ax[cnt].set_xlabel('Study Date')
    ax[cnt].set_ylabel('volume (V/15 minutes)')
    ax[cnt].set_title(station)
    ax[cnt].grid(True)
    ax[cnt].xaxis.set_major_locator(DayLocator())
    ax[cnt].xaxis.set_major_formatter(DateFormatter('%m/%d'))
    ax[cnt].legend(loc='upper left')

    cnt = cnt +1

I added a snapshot of the data

GeoBeez
– GeoBeez

2021-06-07 22:30:24 +00:00
Commented Jun 7, 2021 at 22:30 — GeoBeez
– GeoBeez, Commented Jun 7, 2021 at 22:30
Thanks, I sorted the index and it worked.

GeoBeez
– GeoBeez

2021-06-07 22:32:48 +00:00
Commented Jun 7, 2021 at 22:32 — GeoBeez
– GeoBeez, Commented Jun 7, 2021 at 22:32

john-hen · Accepted Answer · 2021-06-09 15:41:06Z

1

As John Hennig suggested in the comments, I just ordered the index before the plot, and it worked.

gdf = gdf.sort_index()

edited Jun 9, 2021 at 15:41

john-hen

4,9532 gold badges29 silver badges48 bronze badges

answered Jun 7, 2021 at 23:14

GeoBeez

1,0342 gold badges13 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

An additional line in timeseries plot with Matplotlib

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related