Skip to content

Instantly share code, notes, and snippets.

@rbtrsv

rbtrsv/pandas_dataframe_to_firestore_collection.py

Last active September 4, 2022 22:24
Show Gist options
  • Save rbtrsv/fe5c6bfed5dc196b7e80fe243baadc42 to your computer and use it in GitHub Desktop.
Save rbtrsv/fe5c6bfed5dc196b7e80fe243baadc42 to your computer and use it in GitHub Desktop.
Download ZIP
Export Pandas dataframe to Firestore collection
Raw
pandas_dataframe_to_firestore_collection.py
import pandas as pd
# The is an alternative
# from google.cloud import firestore
# db = firestore.Client()
# db = firestore.Client.from_service_account_json("/Users/your.name/yada-yada-firebase-adminsdk.json")
import firebase_admin
from firebase_admin import credentials
from firebase_admin import firestore
cred = credentials.Certificate('/Users/your.name/yada-yada-firebase-adminsdk.json')
app = firebase_admin.initialize_app(cred)
db = firestore.client()
df = pd.DataFrame()
for indices, row in df.iterrows():
doc_ref = db.collection("stocks").document(row['Symbol'])
doc_ref.set({
"Symbol": row['Symbol'],
"Name": row['Name'],
"Sector": row['Sector']
})
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment