'split dict on column (data from firebase)

I have a table on firebase that return me a keyword rank by day.

https://teyia.com.br/imagens/palavrachave.png enter image description here

Now i need to use just keyword rank and data column but my columns is a dict. How can i change it to do return like this?

enter image description here

firebase = pyrebase.initialize_app(firebaseConfig)
db = firebase.database()
data = db.child(base).get()
dicdata = dict(db.child(base).get().val())
dados = pd.DataFrame(dicdata)
print(dados[0:])


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source