how to convert string to float while plot the date with Python matplotlib

Question

I want to draw the close price (y-axis) and date (x-axis) with python, but the error shows that I need to convert date from string to float.

Here is coding:

import numpy as np
import pandas as pd
import matplotlib.pyplot as plt
import matplotlib.dates as dates
import datetime

from pandas import DataFrame, Series

df = pd.read_csv('C:/Users/Vicky/Desktop/pythontest/T1706dailyrecord.csv')

df.columns = [1,2,3,4,5]
print(df)

plt.plot(df[1], df[3])

Put your coding part in Code Sample format, to make it more clear — Anil Agrawal
– Anil Agrawal, Commented May 25, 2017 at 5:56

jezrael · Accepted Answer · 2017-05-25 05:43:54Z

1

I think you need parameter parse_dates for convert column to datetime in read_csv:

df = pd.read_csv('C:/Users/Vicky/Desktop/pythontest/T1706dailyrecord.csv', parse_dates=[0])

Or:

df=pd.read_csv('C:/Users/Vicky/Desktop/pythontest/T1706dailyrecord.csv',parse_dates=['Date'])

Also df.columns = [1,2,3,4,5] is not necessary, for select use: df['Date'] and df['Close']:

plt.plot(df['Date'], df['Close'])

Also is possible use DataFrame.plot:

df.plot(x='Date', y='Close')

edited May 25, 2017 at 5:43

answered May 25, 2017 at 5:37

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

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

Collectives™ on Stack Overflow

how to convert string to float while plot the date with Python matplotlib

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