How to plot this graph using Python properly

Question

I am trying to plot the graph bellow using python, but I am getting an error.

The Python commands I am using are:

import pandas as pd
import matplotlib.pyplot as plt


data = pd.read_csv('data/filtro_bovespa_final.csv')

data.loc[(data['codigo'] == 'BBAS3') & (data['codigo'] == 'BBDC4')]

data.date = pd.to_datetime(data['date'],format='%Y%m%d')
data.set_index(['date','codigo'])
plt.plot(data.date,data.preco)
plt.show()

The error I am getting is:

I got this graph, but it is not what I need:

The csv file I am using: Bovespa

I need a graph that allows me to compare the price linked with both the codes (BBAS3 and BBDC4) as the first graph I showed.

What else should I do to get the graph I need?

What are you trying to do with data.plot and data.show. Do you mean plt.show()? — Quang Hoang
– Quang Hoang, Commented Oct 14, 2020 at 3:45
Judging from the error message, it seems to be data.show, what happens if I comment out? — r-beginners
– r-beginners, Commented Oct 14, 2020 at 3:49
I corrected it... but I got another error... I have updated the question. — Siqueira
– Siqueira, Commented Oct 14, 2020 at 3:54
Yes... the data I presented is on the graph of the figure I uploaded here. I n eed to plot this same figure using python... however, it is not working. Hope you can help me. — Siqueira
– Siqueira, Commented Oct 14, 2020 at 4:06

r-beginners · Accepted Answer · 2020-10-14 06:06:37Z

2

To draw them by attribute, we use a pivot to turn the data frames into columns by attribute. I've also changed the extraction condition to OR.

import pandas as pd
import matplotlib.pyplot as plt

data = pd.read_csv('./Data/filtro_bovespa_final.csv')
data.date = pd.to_datetime(data['date'],format='%Y%m%d')

data = data.loc[(data['codigo'] == 'BBAS3') | (data['codigo'] == 'BBDC4')]
data.set_index('date', inplace=True)
data = data.pivot(columns='codigo')
data.columns = ['BBAS3','BBDC4']

data.plot()

plt.show()

answered Oct 14, 2020 at 6:06

r-beginners

35.6k3 gold badges20 silver badges41 bronze badges

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

Collectives™ on Stack Overflow

How to plot this graph using Python properly

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