how to get MongoDB nested documents in table format using python?

[sharath123]

However the subdocuments will just appear as JSON inside the subdocument cell

from pandas import DataFrame

df = DataFrame(list(db.collection_name.find({}))
print(df)

how can I get a below 2nd table like this using python?

what is the approach for this?

[v-chenwuz-msft · Accepted solution]

Hi @sharath123 

You can refer this code

import pandas as pd
from pandas import DataFrame,Series
df = pd.read_csv('1.csv',sep='\t')
df1 = df['address'].apply(eval).apply(Series)
df2 = pd.concat([df,df1],axis = 1)
df2.drop('address',axis =1, inplace = True)
df2.rename(columns={'number':'address.number','street':'address.street','city':'address.city'},inplace = True)
print(df2)

If something wrong please let me know .

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.