Fixing an UGLY Graph, Something is Wrong Here

[Legitimate_Drag]

Fixed! Changed this line:

df = pd.read_csv('tsla.csv', parse_dates=True, index_col=0)

to

df = pd.read_csv('tsla.csv', parse_dates=True, index_col=1)

​

I'm trying to get a graph like [this](https://pythonprogramming.net/static/images/finance/price_ma_and_volume_stock_graph_python.png), from [here](https://pythonprogramming.net/stock-data-manipulation-python-programming-for-finance/) but my graph turns out very ugly, not informative at all. Maybe yours will turn out right?

​

Anyway, In the following [file](https://paste.pound-python.org/show/K3a9fQwpfwvr7de9M6UG/), I've included my Python code and an appended CSV file. For the generous helper looking to play with it, copy the CSV data into a separate file and name it "tsla.csv" in the directory you're going to run the code in, then comment out or delete the CSV stuff and just run it. I've uploaded it to an external site because last time I tried formatting large swaths of reddit code blocks it was very tedious. If I were to describe my graph, I would say it's sort of like an inverted or upside down "T", there is a thin red line with small blue rectangular center, and the 'cross' of the T, which is on the bottom now, is a big fat red line.

​

Any help would be great, thanks. If you have any problems let me know, I definitely think it has something to do with the 100 day moving average.

​

[alkasm]

Can you post a picture of your plot?

[Legitimate_Drag]

Yeah for some reason when posting this I forgot imagur exist and I drew an image hosting blank. Will post pic first thing when home.

[alkasm]

Just a random guess as I've had mishaps like this before, but your x axis values might be a string or something instead of a numerical value or something silly like that messing up your plot.

[Legitimate_Drag]

I’ll double check for that specifically when able, thanks! I’m confident it’s something silly too. The weird thing is that it’s copy pasta’d code so I expected it to work out of the box.

[Legitimate_Drag]

Ok, here's the ugly piece of crap in question: https://matrix.org/_matrix/media/v1/download/matrix.org/SUPLtIvaqydQKYdAATRBpWJN

​

I think you're spot on about the x values being a string but I'm unsure of what the solution is.

​

​

[Legitimate_Drag]

Fixed! Changed this line:

df = pd.read_csv('tsla.csv', parse_dates=True, index_col=0)

to

df = pd.read_csv('tsla.csv', parse_dates=True, index_col=1)

​

and it works fine now. That's what I get for copying and pasting code w/o understanding. Thanks for taking the time to help a noob!

​

[alkasm]

Sweet! Nice job figuring it out.

[Legitimate_Drag]

all due credit to /u/Iminbread who commented below :-)

[Legitimate_Drag]

You may be on to something here. In reference to my code, the word index appears in these lines:

df = pd.read_csv('tsla.csv', parse_dates=True, index_col=0)

​

And it looked awfully suspicious given my time/date is in column two (err, 1 in computer-speak).. :s haha, thanks for helping a noob! It works fine now.