6

I have the following code:

import matplotlib.pyplot as plt
import numpy as np

import pandas as pd

data = pd.read_csv("Ari_atlag.txt", sep = '\t', header = 0)


#Num_array = pd.DataFrame(data).to_numpy()

print(data.head())
data.plot()
#data.columns = ['Date', 'Number_of_test', 'Avarage_of_ARI']
#print(Num_array)
plt.show()

Output:

     Date    Number_of_test    Avarage_of_ARI 
0  2011-01                22          0.568734
1  2011-02                 5          0.662637
2  2011-03                 0          0.000000
3  2011-04                 3          0.307692
4  2011-05                 6          0.773611

Process finished with exit code 0

and the plot.

But with this code in the plot, the x axis is the index. But I want to get Date in x axis.

How to plot the Date with Number_of_test and Date with Avarage_of_ARI

I think, I somehow should change string(date) to dates, but don't know how to do that.

Best

Improve this question
3
  • When you say "the x-axis is not the date, it is only the index", do you mean that is the plot you are getting, or that is the plot that you want? Commented Nov 8, 2021 at 7:26
  • @StuartMills it is what I get, On the x axis I want to get the date. Commented Nov 8, 2021 at 7:35
  • 1
    Does this answer your question? Matplotlib pandas plot date time Commented Nov 8, 2021 at 7:36

3 Answers 3

Reset to default
6

Try this :

#Excutable example
df = pd.DataFrame({"Date" : ["2011-01", "2011-02", "2011-03", "2011-04", "2011-05"],
                   "Number_of_test" : [22, 5, 0, 3, 6],
                   "Avarage_of_ARI" : [0.568734, 0.662637, 0.000000, 0.307692,
                                       0.773611]})
df.Date = pd.to_datetime(df.Date)
df = df.set_index("Date")

Plot

plt.style.use('ggplot')
plt.rcParams['figure.figsize'] = [13,5]

data_ax1 = df.Number_of_test
data_ax2 = df.Avarage_of_ARI
fig, ax1 = plt.subplots()
        
ax1.set_ylabel('Number_of_test', color = 'tab:red')
ax1.plot(data_ax1, color = 'tab:red', linewidth= 1)
ax1.tick_params(axis = 'y',
                labelcolor= 'tab:red',
                length = 6, 
                width = 1, 
                grid_alpha=0.5)
    
ax2 = ax1.twinx()
ax2.set_ylabel('Avarage_of_ARI', color = 'tab:blue')
ax2.plot(data_ax2, color = 'tab:blue', linewidth = 1)
ax2.tick_params(axis='y', labelcolor = 'tab:blue')
fig.tight_layout()
plt.title("Plot", fontsize = 15)

Result enter image description here

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

Comments

5

Use x='Date' as parameter of plot:

df.plot(x='Date')
plt.show()

enter image description here

Improve this answer

Comments

0

You can set the index to the date column if that works for your data.

cols = ['Number_of_test','Avarage_of_ARI']

data.set_index('Date', inplace = True)

for c in cols:
    data[c].plot()
Improve this answer

Comments

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.