ValueError: invalid literal for int() with base 10: ''

[qn222ad]

Can I ask what is the error of this one and how should I solve them?

ValueError: invalid literal for int() with base 10: ''

These are my data type:
Open      float64
High      float64
Low       float64
Close     float64
Volume      int64
Time        int64 #this one is doing for onclick and take date
the index is datetime index I checked
`if data.index.__class__.__name__ == 'DatetimeIndex': print('true')`

My read function
```python
def read_days_only(df):
    dfn = df.copy()
    dfn.dropna(inplace=True)
    dfn.loc[:,'Date'] = pd.to_datetime(dfn['Date'], errors='coerce',format='%Y-%m-%d',utc=True)
    dfn = dfn.set_index(pd.DatetimeIndex(dfn['Date']))
    return dfn
data = read_days_only(pd.read_csv('data/dfn_dji.csv'))
ax = fplt.create_plot('pivot', rows=1)
fplt.candlestick_ochl(data[['Open','Close','High','Low']],ax=ax)
fplt.show()

[qn222ad]

I found problem was that my data is from 1928 or older that why in pandas used default since 1970.
I set the date as
dfn['Date'] = pd.to_datetime([x for x in range(23823)], unit='D',origin=pd.Timestamp('1928-10-02'))
but it did not work too... now, I do not know how to fix this

[qn222ad]

import finplot as fplt
import pandas as pd

data = read_days_only(pd.read_csv('data/dfn-dji.csv'))
pivot = read_days_only(pd.read_csv('data/df_sq.csv'))
pivot=pivot.sort_index()

def read_days_only(df):
dfn = df.copy()
dfn.loc[:,'Date'] = pd.to_datetime(dfn['Date'], errors='coerce')
dfn = dfn.set_index(pd.DatetimeIndex(dfn['Date'].dt.date))
return dfn
data[f'sq'] = data['Low'][pd.to_datetime(data.index.date.astype(str)).isin(pd.to_datetime(pivot.index.date))]
fplt.candlestick_ochl(data[['Open', 'Close', 'High', 'Low']])
fplt.plot(data[f'sq'], color='#1ad845', style='^', legend=f'square', width=3)

fplt.show()

[highfestiva]

Dunno, works for me. Fetch the latest finplot code and see if that works.

[qn222ad]

I reinstall several times it is still the same. Previously, code run just fine, now all the previous code file, same error...strange..

[highfestiva]

Could be that a necessary patch is not yet released. Try to fetch the latest code here from github and replace your locally installed site-packages/finplot/__init__.py with that.

[qn222ad]

:):) yes, replaced the file works :):) thanks!!!!