Pandas in64 datatype changing when using to_sql for SQLite database

Vote count:

0

I am using pandas to organize and manipulate data I am getting from the twitter API. The 'id' key returns a very long integer (int64) that pandas has no problem handling (i.e. 481496718320496643).

However, when I send to SQL:

df.to_sql('Tweets', conn, flavor='sqlite', if_exists='append', index=False)

I now have tweet id: 481496718320496640 or something close to that number.

I converted the tweet id to str but SQLite still messes with the number. The data type in the SQLite database is [tweet_id] INTEGER. What is going on and how do I prevent this from happening?

asked 2 mins ago

bfs1990

56