PYTHON - df conversion with quote

[reitua7]

Hello guys,

I can't convert my dataframe using Quote class:

data= yf.download(XXXX, period="max", start="2010-01-01", end=date.today(), show_errors=False, progress=False)
data["Date"]=data.index
data = data[["Date", "Open", "High", "Low", "Close", "Adj Close", "Volume"]]
data.reset_index(drop=True, inplace=True)
quotes_list = [Quote(d, o, h, l, c, v) for d in zip(data["Date"], data["Open"], data["High"], data["Low"], date["Close"], data["Volume"] )]

i got a " 'NoneType' value cannot be converted", but my dataframe is:
Date datetime64[ns]
Open float64
High float64
Low float64
Close float64
Adj Close float64
Volume int64

Do you see my mistake ?

[DaveSkender]

Try float64 on Volume

[DaveSkender]

Checkout the guide. Try for d,o,h,l,c,v instead of for d

[reitua7]

Yes sorry i failed the copy/paste… it’s what i did but with no sucess

[DaveSkender]

I'm sure there's something quite simple but I fail to see it. @LeeDongGeon1996 any ideas?

[LeeDongGeon1996]

@reitua7 Sorry for too late reply. I'm very sure that you have None value in your OHLCV dataset. But our library can accept None value as any value of ohlcv. Can you provide us your sample data?

[LeeDongGeon1996]

And full error message also will be helpful.

[DaveSkender]

Tip

For a working example using price quotes from a pandas.DataFrame, see our Replit of the Williams Fractal indicator. If you're having general trouble getting setup, see our QuickStart guide.

See also:

• Help! Converting Pandas DataFrame to iterable Quotes #1165