Load firestore table to pandas dataframe

firestore_to_pandas_dataframe.py

import pandas as pd
from google.cloud import firestore

db = firestore.Client()
users = list(db.collection(u'users').stream())

users_dict = list(map(lambda x: x.to_dict(), users))
df = pd.DataFrame(users_dict)

Thank you!

Exactly what I was looking for, thank you!

Thanks! In my case I needed lowercase .client()

perfect, thanks

Thank you, and if I need to add the ID also?

Thank you, and if I need to add the ID also?

users_dict = list(map(lambda x: {**x.to_dict(), 'id': x.id}, users))
df = pd.DataFrame(users_dict)
df.set_index('id', inplace=True)

optional if you want to convert index to column
df.reset_index()