Guest User

Untitled

a guest
Jan 23rd, 2019
117
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.47 KB | None | 0 0
  1. mylist = [{"a": 1, "b": {"c": 2, "d":3}}, {"a": 3, "b": {"c": 4, "d":3}}]
  2.  
  3. import pandas as pd
  4.  
  5. result_dataframe = pd.DataFrame(mylist)
  6. print(result_dataframe)
  7.  
  8. a b
  9. 0 1 {'c': 2, 'd': 3}
  10. 1 3 {'c': 4, 'd': 3}
  11.  
  12. new_dataframe = result_dataframe.drop(columns=["b"])
  13. b_dict_list = [document["b"] for document in mylist]
  14. b_df = pd.DataFrame(b_dict_list)
  15. frames = [new_dataframe, b_df]
  16. total_frame = pd.concat(frames, axis=1)
  17.  
  18. a c d
  19. 0 1 2 3
  20. 1 3 4 3
Add Comment
Please, Sign In to add comment