CODEWITHSUNDEEP
pythonpandasdatematplotlibx-axis
Martin Kunze
Martin Kunze

Reputation: 1045

Python: Set interval step of x-Axis dates

I have a .csv file of data of following form

Date Company 1 Company 2 ... Company n
01.01.2021 100 20 ... 123
02.01.2021 50 1 ... 455
... ... ... ... ...
8.11.2021 20 23 ... 122

My aim is to choose company x in a Combobox and finally plot it as a graph with

and

In the first step I've a problem with the scale of the x-axis values. My aim is a monthly stepwide but with the code:

import pandas as pd
import matplotlib.pyplot as plt    

df = pd.read_csv('file.csv')
df.set_index('Date')

ax = plt.plot(df['Date'], df['Company 1'])
#ax.xaxis.set_major_locator(mdates.MonthLocator(interval=1))
plt.show()

I get the resultenter image description here The x-values overwrite eachother!

I've tried some solution here but the additional line:

ax.xaxis.set_major_locator(mdates.MonthLocator(interval=1))

gives me the following error:

AttributeError: 'list' object has no attribute 'xaxis'

Upvotes: 0

Views: 897

Answers (1)

Serega
Serega

Reputation: 301

Try this

df = pd.read_csv('file.csv',) 
names = ['Company 1']
features = df[names]
features.index = df['Date']
axs = features.plot(subplots=True)
cursor = MultiCursor(axs[1].get_figure().canvas, axs)
plt.show()

Upvotes: 1

Related Questions