formatting string into date in matplotlib 3.1

Question

A tutorial for older versions of python and matplotlib contains code like this:

def graphRawFX ():
    date,bid,ask = np.loadtxt('GBPUSD1d.txt',
                              unpack=True,
                              delimiter=',',
                              converters={0:mdates.strpdate2num('%Y%m%d%H%M%S')})

    fig = plt.figure(figsize=(10,7))
    ax1 = plt.subplot2grid((40,40),(0,0), rowspan=40,colspan=40)

    ax1.plot(date,bid)
    ax1.plot(date,ask)

    ax1.xaxis.set_major_formatter(mdates.DateFormatter('%Y-%m-%d %H:%M:%S'))

    plt.grid(True)
    plt.show()

graphRawFX()

I get the following error when I run the code:

The strpdate2num class was deprecated in Matplotlib 3.1 and will be removed in 3.3. Use time.strptime or dateutil.parser.parse or datestr2num instead. converters={0:mdates.strpdate2num('%Y%m%d%H%M%S')})

Here is one row of the data for more information:

20130501000000,1.55358,1.55371

so how do I turn that string into dates using matplotlib 3.1?

I'd try with converters={0:lambda x: mdates.date2num(datetime.strptime(x, '%Y%m%d%H%M%S'))} — ImportanceOfBeingErnest
– ImportanceOfBeingErnest, Commented Aug 2, 2019 at 13:21

Amit · Accepted Answer · 2019-08-02 14:17:19Z

6

I think what the warning is asking you to do is use time.strptime function to convert from string to time. You may want to change the first line.

import time
date,bid,ask =np.loadtxt('GBPUSD1d.txt',unpack=True,delimiter=',',converters={0:time.strptime(mdates,'%Y%m%d%H%M%S')})

This is as much I can see based on the error/warning and the cose that was given.

After conversation, I realized that mdates is actually a matplotlib module. Thus suggesting a change. Please try it out.

date,bid,ask = np.loadtxt('GBPUSD1d.txt', unpack=True, delimiter=',', converters={0: lambda x: mdates.datestr2num(x.decode('utf8'))})

Hopefully this will work.

edited Aug 2, 2019 at 14:17

answered Aug 2, 2019 at 13:03

Amit

2,1381 gold badge10 silver badges15 bronze badges

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

11 Comments

Mahdi_J Over a year ago

TypeError: strptime() argument 0 must be str, not <class 'module'> @Amit

Amit Over a year ago

Yes, I assumed mdates is a string. There was little before that to tell otherwise. My assumption was wrong. Is there a function on the class to cast to string first?

Mahdi_J Over a year ago

the code on the reply above didn't work either because datetime has no attribute 'strptime'. and no there is no such function. i've copied the whole project in here.

Amit Over a year ago

is there an import such as "import matplotlib.dates as mdates"?

Mahdi_J Over a year ago

yes. these are all the imported functions if thats what you mean. i apologize if i don't understand 100% i am fairly new at this. import matplotlib as mpl import matplotlib.pyplot as plt import matplotlib.ticker as mticker import matplotlib.dates as mdates import numpy as np import datetime

|

Collectives™ on Stack Overflow

formatting string into date in matplotlib 3.1

1 Answer 1

11 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

11 Comments

Your Answer

Sign up or log in

Post as a guest

Related