pandas not labeling date ticks

Question

New to programming. Trying to plot a dataframe with pandas, but just the date label shows up with no ticks.

import pandas as pd
import matplotlib.pyplot as plt
plt.style.use('fivethirtyeight') 


#Read in Data set date as index
cattle_ppi = pd.read_csv('C:/Users/SkyLH/Documents/Cattle Forcast Model/Producer Price Index Corn.csv', index_col = 'DATE')
corn_ppi = pd.read_csv('C:/Users/SkyLH/Documents/Cattle Forcast Model/Producer Price Index Slaughter Cattle.csv', index_col = 'DATE')


#Combine Data
df = cattle_ppi.join(corn_ppi)
df.columns = ('Cattle PPI', 'Corn PPI')

print(df.head())
print(df.tail())

df.plot()
plt.show()
            Cattle PPI  Corn PPI
DATE                            
1971-01-01        63.4      44.8
1971-02-01        63.6      50.5
1971-03-01        62.0      50.4
1971-04-01        60.8      51.6
1971-05-01        60.2      52.0
            Cattle PPI  Corn PPI
DATE                            
2018-04-01       148.4     177.9
2018-05-01       154.2     171.7
2018-06-01       144.8     167.5
2018-07-01       132.1     168.5
2018-08-01       137.6     164.7

Picture of the Plot.

Try df.index = pd.to_datetime(df.index) before the df.plot(). You are trying to show categorical values the x axis instead of datetime. — Scott Boston
– Scott Boston, Commented Sep 19, 2018 at 15:20

Khalil Al Hooti · Accepted Answer · 2018-09-19 15:36:12Z

0

It is duplicate Plot pandas dates in matplotlib

But the answer is as follows for your case

import numpy as np
import pandas as pd
time = pd.date_range(start='1971-01-01', end='2018-08-01', periods=100)
a= np.random.randint(60, high=165, size=100)
b= np.random.randint(20, high=60, size=100)
df = pd.DataFrame({'time': time, 'a': a, 'b': b})
df['time'] = df['time'].dt.date

df.set_index(['time'],inplace=True)
df.plot()

answered Sep 19, 2018 at 15:36

Khalil Al Hooti

4,6065 gold badges28 silver badges51 bronze badges

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

Collectives™ on Stack Overflow

pandas not labeling date ticks

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related