sqlite3.OperationalError: no such table: cu.data.2.Summaries

[killianmcshane]

I'm getting this error with the following code:

import cpi

cpi.update()

dataframe = cpi.series.get(seasonally_adjusted=False).to_dataframe()

print(dataframe)

This was working yesterday, any ideas?

[palewire]

Hmm. We got a new data update from the BLS earlier this week. Could the fresh data have introduced a wrinkle the code isn't handling?

…

On Sat, Feb 18, 2023, at 6:05 AM, Killian Jochen McShane wrote: I'm getting this error with the following code: `cpi.update() dataframe = cpi.series.get(seasonally_adjusted=False).to_dataframe() print(dataframe)` This was working yesterday, any ideas? — Reply to this email directly, view it on GitHub <#70>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AAACOCISBMTERZR2C5KLWVTWYCUHXANCNFSM6AAAAAAVAJC4IM>. You are receiving this because you are subscribed to this thread.Message ID: ***@***.***>

[palewire]

This code just worked for me today. Are you still having this bug?

>>> import cpi
>>> 
>>> cpi.update()
>>> 
>>> dataframe = cpi.series.get(seasonally_adjusted=False).to_dataframe()
>>> 
>>> print(dataframe)
      year        date  value    series_id  ... period_abbreviation     period_name  period_month period_type
0     1997  1997-01-01  160.5  CUUR0000SA0  ...               AN AV  Annual Average             1      annual
1     1998  1998-01-01  163.0  CUUR0000SA0  ...               AN AV  Annual Average             1      annual
2     1999  1999-01-01  166.6  CUUR0000SA0  ...               AN AV  Annual Average             1      annual
3     2000  2000-01-01  172.2  CUUR0000SA0  ...               AN AV  Annual Average             1      annual
4     2001  2001-01-01  177.1  CUUR0000SA0  ...               AN AV  Annual Average             1      annual
...    ...         ...    ...          ...  ...                 ...             ...           ...         ...
1427  1996  1996-08-01  157.3  CUUR0000SA0  ...                 AUG          August             8     monthly
1428  1996  1996-09-01  157.8  CUUR0000SA0  ...                 SEP       September             9     monthly
1429  1996  1996-10-01  158.3  CUUR0000SA0  ...                 OCT         October            10     monthly
1430  1996  1996-11-01  158.6  CUUR0000SA0  ...                 NOV        November            11     monthly
1431  1996  1996-12-01  158.6  CUUR0000SA0  ...                 DEC        December            12     monthly

[1432 rows x 22 columns]

[palewire]

I've attempted to patch this bug, and better test for its future recurrence. Please upgrade to version 1.0.18 and try again. Assuming it's fixed, I'll close this ticket. If you still have the problem, please speak up.