I'm trying to export all the data from my replit db

Question

I'm currently trying to move a tonne of data out of replit db by converting it into CSV using pandas

Is it to do with how the data is stored into the db? Is it a mistake to treat the db like a dictionary?

I tried this

Data = pd.DataFrame(db) 
Data.to_csv('data.csv') 

I only get the keys and not the actual data.

i.e.

, 0
1, key1
2, key2
3, key3

Answer 1

Yeah turns out I can't export db into CSV in a file explorer type of format. I thought I could do that. The way I am working around is by creating seperate files for each key as not all keys can be exported into CSV for my context.

What do I mean by file explorer format? I thought I could export it in such a way that when I reference the CSV I can call it like a dictionary. But not all the data stored in each key was in dictionary format. Some were list, bunch of text or ints