Pandas/matplotlib line plot does not show x axis text labels

Question

Issue

Plotting data from a DataFrame into a line plot excludes "dates" on the x axis.

north_result = list(data.aggregate(pipeline))

dates =['Jun','Jul','Aug','Sep','Oct','Nov','Dec','Jan','Feb','Mar','Apr','May']
north_result_df = pd.DataFrame(north_result, index=dates)
north_result_df.index.name = 'Months'
north_result_df.plot.line()

Line plot requires dates just above 'months' on the x axis. Dates show if they are numeric and not strings...any help would be greatly appreciated! As you can tell i am pretty new to Pandas...

Solution

north_result = list(data.aggregate(pipeline))

dates =['Jun','Jul','Aug','Sep','Oct','Nov','Dec','Jan','Feb','Mar','Apr','May']
north_result_df = pd.DataFrame(north_result, index=dates)
north_result_df.index.name = 'Months'
plt.plot(north_result_df.index, north_result_df["total"])
plt.show()

Which version of pandas? In my 0.24.1 it works and looks as expected. — JoergVanAken
– JoergVanAken, Commented Mar 8, 2019 at 15:23
My suggestion would be the same as the answer below: use matplotlib directly instead. — ImportanceOfBeingErnest
– ImportanceOfBeingErnest, Commented Mar 8, 2019 at 19:43
I have no idea what list(data.aggregate(pipeline)) does. But if you have a usual dataframe with numerical values in a column and a normal index (no multiindex, no PeriodIndex) you can use plt.plot(df.index, df["column"]). — ImportanceOfBeingErnest
– ImportanceOfBeingErnest, Commented Mar 8, 2019 at 19:47

Rehim Alizadeh · Accepted Answer · 2019-03-08 14:59:37Z

2

you can use pyplot

import matplotlib.pyplot as plt
north_result =[5,6,7,2,8,5,4,8,9,4,1,5]
dates =['Jun','Jul','Aug','Sep','Oct','Nov','Dec','Jan','Feb','Mar','Apr','May']
north_result_df = pd.DataFrame(north_result, index=dates)
north_result_df.index.name = 'Months'
plt.plot(north_result_df)
plt.show()

the result will be like:

answered Mar 8, 2019 at 14:59

Rehim Alizadeh

3791 gold badge3 silver badges13 bronze badges

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

2 Comments

bsod_ Over a year ago

Cheers however I now get - TypeError: unhashable type: 'numpy.ndarray' - north_result_df is declared as follows = north_result = list(street.aggregate(pipeline))

bsod_ Over a year ago

Final solution added to question

Collectives™ on Stack Overflow

Pandas/matplotlib line plot does not show x axis text labels

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related