API tools faq
paste
Advertisement
Guest User

JSON to Pandas Dataframe

a guest
Aug 26th, 2021
37
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 7.70 KB | None | 0 0
raw download clone embed print report
  1.  
  2. data = [{'event_date': '20210823',
  3. 'event_timestamp': '1629731052175000',
  4. 'event_previous_timestamp': '1629730783704000',
  5. 'event_server_timestamp_offset': '501283',
  6. 'event_name': 'session_start',
  7. 'event_bundle_sequence_id': '29',
  8. 'user_id': None,
  9. 'user_pseudo_id': 'BFAB6907F2A4426C97A432533963EA5F',
  10. 'stream_id': '1391963168',
  11. 'user_properties': [{'key': 'game_segment',
  12. 'value': {'string_value': '0',
  13. 'int_value': None,
  14. 'float_value': None,
  15. 'double_value': None,
  16. 'set_timestamp_micros': '1629730803389000'}},
  17. {'key': 'email_verified',
  18. 'value': {'string_value': '1',
  19. 'int_value': None,
  20. 'float_value': None,
  21. 'double_value': None,
  22. 'set_timestamp_micros': '1629644188370000'}},
  23. {'key': 'Email',
  24. 'value': {'string_value': 'test@gmail.com',
  25. 'int_value': None,
  26. 'float_value': None,
  27. 'double_value': None,
  28. 'set_timestamp_micros': '1629730803388000'}},
  29. {'key': 'is_player',
  30. 'value': {'string_value': '0',
  31. 'int_value': None,
  32. 'float_value': None,
  33. 'double_value': None,
  34. 'set_timestamp_micros': '1629730803387000'}},
  35. {'key': 'registered_sdk_version',
  36. 'value': {'string_value': '4.4',
  37. 'int_value': None,
  38. 'float_value': None,
  39. 'double_value': None,
  40. 'set_timestamp_micros': '1629644188370000'}},
  41. {'key': 'first_open_time',
  42. 'value': {'string_value': None,
  43. 'int_value': '1629644400000',
  44. 'float_value': None,
  45. 'double_value': None,
  46. 'set_timestamp_micros': '1629644045848000'}},
  47. {'key': 'ga_session_number',
  48. 'value': {'string_value': None,
  49. 'int_value': '4',
  50. 'float_value': None,
  51. 'double_value': None,
  52. 'set_timestamp_micros': '1629811998362000'}},
  53. {'key': 'registration_platform',
  54. 'value': {'string_value': 'iOS',
  55. 'int_value': None,
  56. 'float_value': None,
  57. 'double_value': None,
  58. 'set_timestamp_micros': '1629644188370000'}},
  59. {'key': 'registration_language',
  60. 'value': {'string_value': 'en_us',
  61. 'int_value': None,
  62. 'float_value': None,
  63. 'double_value': None,
  64. 'set_timestamp_micros': '1629644188370000'}},
  65. {'key': 'Identity',
  66. 'value': {'string_value': '1655515',
  67. 'int_value': None,
  68. 'float_value': None,
  69. 'double_value': None,
  70. 'set_timestamp_micros': '1629730803387000'}},
  71. {'key': 'email_id',
  72. 'value': {'string_value': 'test@gmail.com',
  73. 'int_value': None,
  74. 'float_value': None,
  75. 'double_value': None,
  76. 'set_timestamp_micros': '1629730803389000'}},
  77. {'key': 'current_locale',
  78. 'value': {'string_value': 'en-za',
  79. 'int_value': None,
  80. 'float_value': None,
  81. 'double_value': None,
  82. 'set_timestamp_micros': '1629730803389000'}},
  83. {'key': 'player_count',
  84. 'value': {'string_value': '1',
  85. 'int_value': None,
  86. 'float_value': None,
  87. 'double_value': None,
  88. 'set_timestamp_micros': '1629730803387000'}},
  89. {'key': 'current_osVersion',
  90. 'value': {'string_value': 'iOS 12.5.4',
  91. 'int_value': None,
  92. 'float_value': None,
  93. 'double_value': None,
  94. 'set_timestamp_micros': '1629730803390000'}},
  95. {'key': 'session_id',
  96. 'value': {'string_value': '49edf09e-6d01-4189-a8f0-10441ce45737',
  97. 'int_value': None,
  98. 'float_value': None,
  99. 'double_value': None,
  100. 'set_timestamp_micros': '1629730803388000'}},
  101. {'key': 'registration_date',
  102. 'value': {'string_value': '2021-08-22T14:56:28Z',
  103. 'int_value': None,
  104. 'float_value': None,
  105. 'double_value': None,
  106. 'set_timestamp_micros': '1629644188370000'}},
  107. {'key': 'ga_session_id',
  108. 'value': {'string_value': None,
  109. 'int_value': '1629731052',
  110. 'float_value': None,
  111. 'double_value': None,
  112. 'set_timestamp_micros': '1629731052175000'}},
  113. {'key': 'trialist',
  114. 'value': {'string_value': '0',
  115. 'int_value': None,
  116. 'float_value': None,
  117. 'double_value': None,
  118. 'set_timestamp_micros': '1629730803387000'}},
  119. {'key': 'orientation',
  120. 'value': {'string_value': 'landscape',
  121. 'int_value': None,
  122. 'float_value': None,
  123. 'double_value': None,
  124. 'set_timestamp_micros': '1629730803389000'}},
  125. {'key': 'current_language',
  126. 'value': {'string_value': 'en_us',
  127. 'int_value': None,
  128. 'float_value': None,
  129. 'double_value': None,
  130. 'set_timestamp_micros': '1629730803389000'}},
  131. {'key': 'current_sdk_version',
  132. 'value': {'string_value': '4.4',
  133. 'int_value': None,
  134. 'float_value': None,
  135. 'double_value': None,
  136. 'set_timestamp_micros': '1629730803389000'}},
  137. {'key': 'current_player_id',
  138. 'value': {'string_value': '205622',
  139. 'int_value': None,
  140. 'float_value': None,
  141. 'double_value': None,
  142. 'set_timestamp_micros': '1629730803387000'}},
  143. {'key': 'is_user',
  144. 'value': {'string_value': '1',
  145. 'int_value': None,
  146. 'float_value': None,
  147. 'double_value': None,
  148. 'set_timestamp_micros': '1629730803387000'}},
  149. {'key': 'registration_locale',
  150. 'value': {'string_value': 'en-za',
  151. 'int_value': None,
  152. 'float_value': None,
  153. 'double_value': None,
  154. 'set_timestamp_micros': '1629644188370000'}},
  155. {'key': 'registration_game',
  156. 'value': {'string_value': 'bakery',
  157. 'int_value': None,
  158. 'float_value': None,
  159. 'double_value': None,
  160. 'set_timestamp_micros': '1629644188370000'}},
  161. {'key': 'device_model',
  162. 'value': {'string_value': 'iPhone6,2',
  163. 'int_value': None,
  164. 'float_value': None,
  165. 'double_value': None,
  166. 'set_timestamp_micros': '1629730803389000'}},
  167. {'key': 'os_version',
  168. 'value': {'string_value': 'iOS 12.5.4',
  169. 'int_value': None,
  170. 'float_value': None,
  171. 'double_value': None,
  172. 'set_timestamp_micros': '1629644188370000'}},
  173. {'key': 'current_game',
  174. 'value': {'string_value': 'bakery',
  175. 'int_value': None,
  176. 'float_value': None,
  177. 'double_value': None,
  178. 'set_timestamp_micros': '1629730803389000'}}],
  179. 'event_params': [{'key': 'firebase_conversion',
  180. 'value': {'string_value': None,
  181. 'int_value': '1',
  182. 'float_value': None,
  183. 'double_value': None}},
  184. {'key': 'ga_session_number',
  185. 'value': {'string_value': None,
  186. 'int_value': '4',
  187. 'float_value': None,
  188. 'double_value': None}},
  189. {'key': 'engaged_session_event',
  190. 'value': {'string_value': None,
  191. 'int_value': '1',
  192. 'float_value': None,
  193. 'double_value': None}},
  194. {'key': 'ga_session_id',
  195. 'value': {'string_value': None,
  196. 'int_value': '1629731052',
  197. 'float_value': None,
  198. 'double_value': None}},
  199. {'key': 'firebase_event_origin',
  200. 'value': {'string_value': 'auto',
  201. 'int_value': None,
  202. 'float_value': None,
  203. 'double_value': None}}],
  204. 'device': {'category': 'mobile',
  205. 'mobile_brand_name': 'Apple',
  206. 'mobile_model_name': 'iPhone 5s',
  207. 'mobile_marketing_name': None,
  208. 'mobile_os_hardware_model': 'iPhone6,2',
  209. 'operating_system': 'iOS',
  210. 'operating_system_version': 'iOS 12.5.4',
  211. 'vendor_id': 'BCFF216C-D028-49F2-8541-CD7EF3C8F904',
  212. 'advertising_id': None,
  213. 'language': 'en-za',
  214. 'is_limited_ad_tracking': 'No',
  215. 'time_zone_offset_seconds': '7200',
  216. 'browser': None,
  217. 'browser_version': None,
  218. 'web_info': None},
  219. 'geo': {'continent': 'Africa',
  220. 'country': 'South Africa',
  221. 'region': 'Western Cape',
  222. 'city': 'Cape Town',
  223. 'sub_continent': 'Southern Africa',
  224. 'metro': '(not set)'},
  225. 'app_info': {'id': 'skidos.bakery',
  226. 'version': '36',
  227. 'install_store': None,
  228. 'firebase_app_id': '1:174186224775:ios:0c4c6a57a3a5d1a1',
  229. 'install_source': 'iTunes'},
  230. 'traffic_source': {'name': '(direct)',
  231. 'medium': '(none)',
  232. 'source': '(direct)'},
  233. 'platform': 'IOS'}]
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!