Advertisement
Guest User

Untitled

a guest
Sep 12th, 2019
152
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 0.80 KB | None | 0 0
  1. import pandas as pd
  2. import json
  3.  
  4.  
  5. data = [dict(grupa1='wartosc1', grupa2='wartosc1', cos1='wartosc', cos2='wartosc', cos3='wartosc'),
  6.         dict(grupa1='wartosc1', grupa2='wartosc2', cos1='wartosc', cos2='wartosc', cos3='wartosc'),
  7.         dict(grupa1='wartosc1', grupa2='wartosc2', cos1='test', cos2='wartosc', cos3='wartosc'),
  8.         dict(grupa1='wartosc2', grupa2='wartosc3', cos1='wartosc', cos2='wartosc', cos3='wartosc'),
  9.         dict(grupa1='wartosc2', grupa2='wartosc4', cos1='wartosc', cos2='wartosc', cos3='wartosc')]
  10.  
  11. df = pd.DataFrame(data)
  12.  
  13.  
  14.  
  15. result1 = {}
  16. for key1, df1 in df.groupby(['grupa1']):
  17.     result2 = {}
  18.     for key2, df2 in df1.groupby(['grupa2']):
  19.         result2[str(key2)] = df2.drop(columns=['grupa1', 'grupa2']).to_dict('records')
  20.     result1[str(key1)] = result2
  21.  
  22. print(json.dumps(result1, indent=4))
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement