Python - Matplotlib plots incorrect graph when using pandas dataframe

Question

(My first ever StackOverflow question)

I'm trying to plot bitcoin's market-cap against the date using pandas and matplotlib in Python.

Here is my code:

%matplotlib inline
import pandas as pd
import numpy as np
import matplotlib.pyplot as plt

#read in CSV file using Pandas built in method
df = pd.read_csv("btc.csv", index_col=0, parse_dates=True)

Here are some details about the data frame: dataframe details

matplotlib code:

#Plot marketcap(usd)
plt.plot(df.index, df["marketcap(USD)"])
plt.show()

Result: Incorrect result

The plot seems to be more like scribbles that seem to move backwards. How could I fix this?

Looks like your data is not sorted by the date.

taras
– taras

2018-06-24 17:32:42 +00:00
Commented Jun 24, 2018 at 17:32 — taras
– taras, Commented Jun 24, 2018 at 17:32

PythonSherpa · Accepted Answer · 2018-06-24 18:18:33Z

1

You can plot your Pandas Series "marketcap(USD)" directly using:

df["marketcap(USD)"].plot()

See the Pandas documentation on Basic Plotting

edited Jun 24, 2018 at 18:18

answered Jun 24, 2018 at 18:11

PythonSherpa

2,6004 gold badges22 silver badges41 bronze badges

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

Collectives™ on Stack Overflow

Python - Matplotlib plots incorrect graph when using pandas dataframe

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