处理 pandas 中的嵌套json [英] handling nested json in pandas

查看:96
本文介绍了处理 pandas 中的嵌套json的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我正在尝试使用read_json用熊猫处理嵌套的json,但我得到的重复输入如下所示:

I'm trying to handle nested json with pandas using read_json, but I am getting repeated entries like shown here:

contributors_enabled               2013-11-30 20:48:42   
created_at                         2013-11-30 20:48:42   
default_profile                    2013-11-30 20:48:42   
default_profile_image              2013-11-30 20:48:42   
description                        2013-11-30 20:48:42   
favourites_count                   2013-11-30 20:48:42   
follow_request_sent                2013-11-30 20:48:42   
...
                                                                           source  \
contributors_enabled                <a href="http://twitter.com/download/iphone" r...   
created_at                          <a href="http://twitter.com/download/iphone" r...   
default_profile                     <a href="http://twitter.com/download/iphone" r...   
default_profile_image               <a href="http://twitter.com/download/iphone" r...   
description                         <a href="http://twitter.com/download/iphone" r...   
favourites_count                    <a href="http://twitter.com/download/iphone" r...   
follow_request_sent...

如何将其更改为正确的格式?

how can this be changed to correct format?

我正在使用以下代码:

for line in gzip.open("/home/amrith/shared/twitter-stream/tweets-1385844523.txt.gz"):
    tweet = read_json(line)
    print(tweet)

输入行如下:

{'contributors': None,
 'coordinates': None,
 'created_at': 'Sun Dec 01 01:19:00 +0000 2013',
 'entities': {'hashtags': [], 'symbols': [], 'urls': [], 'user_mentions': []},
 'favorite_count': 0,
 'favorited': False,
 'filter_level': 'medium',
 'geo': None,
 'id': 12345,
 'id_str': '12345',
 'in_reply_to_screen_name': None,
 'in_reply_to_status_id': None,
 'in_reply_to_status_id_str': None,
 'in_reply_to_user_id': None,
 'in_reply_to_user_id_str': None,
 'lang': 'es',
 'place': None,
 'retweet_count': 0,
 'retweeted': False,
 'source': '<a href="http:\\/\\/blackberry.com\\/twitter" '
           'rel="nofollow">Twitter for BlackBerry®<\\/a>',
 'text': 'Todo va a estar bn :D',
 'truncated': False,
 'user': {'contributors_enabled': False,
          'created_at': 'Sun Feb 05 02:04:16 +0000 2012',
          'default_profile': False,
          'default_profile_image': False,
          'description': 'No pretendo ser nadie mas y no soy perfecta lo se, '
                         'tengo muchos errores también lo se pero me acepto y '
                         'me amo como soy.',
          'favourites_count': 218,
          'follow_request_sent': None,
          'followers_count': 71,
          'following': None,
          'friends_count': 64,
          'geo_enabled': True,
          'id': 54321,
          'id_str': '54321',
          'is_translator': False,
          'lang': 'es',
          'listed_count': 0,
          'location': '',
          'name': 'xxxxx',
          'notifications': None,
          'profile_background_color': 'DBE9ED',
          'profile_background_image_url': 'http:\\/\\/a0.twimg.com\\/profile_background_images\\/378800000116209016\\/ff11dc9f5a2e05d2800a91cff08c2c73.jpeg',
          'profile_background_image_url_https': 'https:\\/\\/si0.twimg.com\\/profile_background_images\\/378800000116209016\\/ff11dc9f5a2e05d2800a91cff08c2c73.jpeg',
          'profile_background_tile': True,
          'profile_banner_url': 'https:\\/\\/pbs.twimg.com\\/profile_banners\\/483470963\\/1385144720',
          'profile_image_url': 'http:\\/\\/pbs.twimg.com\\/profile_images\\/378800000736604157\\/b6d36df6332a2cacb0d30b5328b668d6_normal.jpeg',
          'profile_image_url_https': 'https:\\/\\/pbs.twimg.com\\/profile_images\\/378800000736604157\\/b6d36df6332a2cacb0d30b5328b668d6_normal.jpeg',
          'profile_link_color': '9D1DCF',
          'profile_sidebar_border_color': 'FFFFFF',
          'profile_sidebar_fill_color': 'E6F6F9',
          'profile_text_color': '333333',
          'profile_use_background_image': True,
          'protected': False,
          'screen_name': 'xxxxx',
          'statuses_count': 10407,
          'time_zone': 'Central Time (US & Canada)',
          'url': None,
          'utc_offset': -21600,
          'verified': False}}

推荐答案

使用递归展平嵌套的dicts

  • 在Python中进行递归思考
  • 在Python中平整JSON对象
  • 展平
  • 以下函数将用于展平_source_list
  • Use recursion to flatten the nested dicts

    • Thinking Recursively in Python
    • Flattening JSON objects in Python
    • flatten
    • The following function, will be used to flatten _source_list
    • def flatten_json(nested_json: dict, exclude: list=['']) -> dict:
          """
          Flatten a list of nested dicts.
          """
          out = dict()
          def flatten(x: (list, dict, str), name: str='', exclude=exclude):
              if type(x) is dict:
                  for a in x:
                      if a not in exclude:
                          flatten(x[a], f'{name}{a}_')
              elif type(x) is list:
                  i = 0
                  for a in x:
                      flatten(a, f'{name}{i}_')
                      i += 1
              else:
                  out[name[:-1]] = x
      
          flatten(nested_json)
          return out
      

      数据:

      • 要创建数据集,我使用了给定的数据三次,

        Data:

        • To create the dataset, I used the given data, three times

          1. datajson

        • data = {'stuff': [{"created_at":"Sun Dec 01 01:19:00 +0000 2013","id":12345,"id_str":"12345","text":"Todo va a estar bn :D","source":"\u003ca href=\"http:\/\/blackberry.com\/twitter\" rel=\"nofollow\"\u003eTwitter for BlackBerry\u00ae\u003c\/a\u003e","truncated":False,"in_reply_to_status_id":null,"in_reply_to_status_id_str":null,"in_reply_to_user_id":null,"in_reply_to_user_id_str":null,"in_reply_to_screen_name":null,"user":{"id":54321,"id_str":"54321","name":"xxxxx","screen_name":"xxxxx","location":"","url":null,"description":"No pretendo ser nadie mas y no soy perfecta lo se, tengo muchos errores tambi\u00e9n lo se pero me acepto y me amo como soy.","protected":false,"followers_count":71,"friends_count":64,"listed_count":0,"created_at":"Sun Feb 05 02:04:16 +0000 2012","favourites_count":218,"utc_offset":-21600,"time_zone":"Central Time (US & Canada)","geo_enabled":True,"verified":False,"statuses_count":10407,"lang":"es","contributors_enabled":False,"is_translator":False,"profile_background_color":"DBE9ED","profile_background_image_url":"http:\/\/a0.twimg.com\/profile_background_images\/378800000116209016\/ff11dc9f5a2e05d2800a91cff08c2c73.jpeg","profile_background_image_url_https":"https:\/\/si0.twimg.com\/profile_background_images\/378800000116209016\/ff11dc9f5a2e05d2800a91cff08c2c73.jpeg","profile_background_tile":true,"profile_image_url":"http:\/\/pbs.twimg.com\/profile_images\/378800000736604157\/b6d36df6332a2cacb0d30b5328b668d6_normal.jpeg","profile_image_url_https":"https:\/\/pbs.twimg.com\/profile_images\/378800000736604157\/b6d36df6332a2cacb0d30b5328b668d6_normal.jpeg","profile_banner_url":"https:\/\/pbs.twimg.com\/profile_banners\/483470963\/1385144720","profile_link_color":"9D1DCF","profile_sidebar_border_color":"FFFFFF","profile_sidebar_fill_color":"E6F6F9","profile_text_color":"333333","profile_use_background_image":True,"default_profile":False,"default_profile_image":False,"following":null,"follow_request_sent":null,"notifications":null},"geo":null,"coordinates":null,"place":null,"contributors":null,"retweet_count":0,"favorite_count":0,"entities":{"hashtags":[],"symbols":[],"urls":[],"user_mentions":[]},"favorited":False,"retweeted":False,"filter_level":"medium","lang":"es"},
                            {"created_at":"Sun Dec 01 01:19:00 +0000 2013","id":12345,"id_str":"12345","text":"Todo va a estar bn :D","source":"\u003ca href=\"http:\/\/blackberry.com\/twitter\" rel=\"nofollow\"\u003eTwitter for BlackBerry\u00ae\u003c\/a\u003e","truncated":False,"in_reply_to_status_id":null,"in_reply_to_status_id_str":null,"in_reply_to_user_id":null,"in_reply_to_user_id_str":null,"in_reply_to_screen_name":null,"user":{"id":54321,"id_str":"54321","name":"xxxxx","screen_name":"xxxxx","location":"","url":null,"description":"No pretendo ser nadie mas y no soy perfecta lo se, tengo muchos errores tambi\u00e9n lo se pero me acepto y me amo como soy.","protected":false,"followers_count":71,"friends_count":64,"listed_count":0,"created_at":"Sun Feb 05 02:04:16 +0000 2012","favourites_count":218,"utc_offset":-21600,"time_zone":"Central Time (US & Canada)","geo_enabled":True,"verified":False,"statuses_count":10407,"lang":"es","contributors_enabled":False,"is_translator":False,"profile_background_color":"DBE9ED","profile_background_image_url":"http:\/\/a0.twimg.com\/profile_background_images\/378800000116209016\/ff11dc9f5a2e05d2800a91cff08c2c73.jpeg","profile_background_image_url_https":"https:\/\/si0.twimg.com\/profile_background_images\/378800000116209016\/ff11dc9f5a2e05d2800a91cff08c2c73.jpeg","profile_background_tile":true,"profile_image_url":"http:\/\/pbs.twimg.com\/profile_images\/378800000736604157\/b6d36df6332a2cacb0d30b5328b668d6_normal.jpeg","profile_image_url_https":"https:\/\/pbs.twimg.com\/profile_images\/378800000736604157\/b6d36df6332a2cacb0d30b5328b668d6_normal.jpeg","profile_banner_url":"https:\/\/pbs.twimg.com\/profile_banners\/483470963\/1385144720","profile_link_color":"9D1DCF","profile_sidebar_border_color":"FFFFFF","profile_sidebar_fill_color":"E6F6F9","profile_text_color":"333333","profile_use_background_image":True,"default_profile":False,"default_profile_image":False,"following":null,"follow_request_sent":null,"notifications":null},"geo":null,"coordinates":null,"place":null,"contributors":null,"retweet_count":0,"favorite_count":0,"entities":{"hashtags":[],"symbols":[],"urls":[],"user_mentions":[]},"favorited":False,"retweeted":False,"filter_level":"medium","lang":"es"},
                            {"created_at":"Sun Dec 01 01:19:00 +0000 2013","id":12345,"id_str":"12345","text":"Todo va a estar bn :D","source":"\u003ca href=\"http:\/\/blackberry.com\/twitter\" rel=\"nofollow\"\u003eTwitter for BlackBerry\u00ae\u003c\/a\u003e","truncated":False,"in_reply_to_status_id":null,"in_reply_to_status_id_str":null,"in_reply_to_user_id":null,"in_reply_to_user_id_str":null,"in_reply_to_screen_name":null,"user":{"id":54321,"id_str":"54321","name":"xxxxx","screen_name":"xxxxx","location":"","url":null,"description":"No pretendo ser nadie mas y no soy perfecta lo se, tengo muchos errores tambi\u00e9n lo se pero me acepto y me amo como soy.","protected":false,"followers_count":71,"friends_count":64,"listed_count":0,"created_at":"Sun Feb 05 02:04:16 +0000 2012","favourites_count":218,"utc_offset":-21600,"time_zone":"Central Time (US & Canada)","geo_enabled":True,"verified":False,"statuses_count":10407,"lang":"es","contributors_enabled":False,"is_translator":False,"profile_background_color":"DBE9ED","profile_background_image_url":"http:\/\/a0.twimg.com\/profile_background_images\/378800000116209016\/ff11dc9f5a2e05d2800a91cff08c2c73.jpeg","profile_background_image_url_https":"https:\/\/si0.twimg.com\/profile_background_images\/378800000116209016\/ff11dc9f5a2e05d2800a91cff08c2c73.jpeg","profile_background_tile":true,"profile_image_url":"http:\/\/pbs.twimg.com\/profile_images\/378800000736604157\/b6d36df6332a2cacb0d30b5328b668d6_normal.jpeg","profile_image_url_https":"https:\/\/pbs.twimg.com\/profile_images\/378800000736604157\/b6d36df6332a2cacb0d30b5328b668d6_normal.jpeg","profile_banner_url":"https:\/\/pbs.twimg.com\/profile_banners\/483470963\/1385144720","profile_link_color":"9D1DCF","profile_sidebar_border_color":"FFFFFF","profile_sidebar_fill_color":"E6F6F9","profile_text_color":"333333","profile_use_background_image":True,"default_profile":False,"default_profile_image":False,"following":null,"follow_request_sent":null,"notifications":null},"geo":null,"coordinates":null,"place":null,"contributors":null,"retweet_count":0,"favorite_count":0,"entities":{"hashtags":[],"symbols":[],"urls":[],"user_mentions":[]},"favorited":False,"retweeted":False,"filter_level":"medium","lang":"es"}]}
          

          1. datadictslist

          data = [{"created_at":"Sun Dec 01 01:19:00 +0000 2013","id":12345,"id_str":"12345","text":"Todo va a estar bn :D","source":"\u003ca href=\"http:\/\/blackberry.com\/twitter\" rel=\"nofollow\"\u003eTwitter for BlackBerry\u00ae\u003c\/a\u003e","truncated":False,"in_reply_to_status_id":null,"in_reply_to_status_id_str":null,"in_reply_to_user_id":null,"in_reply_to_user_id_str":null,"in_reply_to_screen_name":null,"user":{"id":54321,"id_str":"54321","name":"xxxxx","screen_name":"xxxxx","location":"","url":null,"description":"No pretendo ser nadie mas y no soy perfecta lo se, tengo muchos errores tambi\u00e9n lo se pero me acepto y me amo como soy.","protected":false,"followers_count":71,"friends_count":64,"listed_count":0,"created_at":"Sun Feb 05 02:04:16 +0000 2012","favourites_count":218,"utc_offset":-21600,"time_zone":"Central Time (US & Canada)","geo_enabled":True,"verified":False,"statuses_count":10407,"lang":"es","contributors_enabled":False,"is_translator":False,"profile_background_color":"DBE9ED","profile_background_image_url":"http:\/\/a0.twimg.com\/profile_background_images\/378800000116209016\/ff11dc9f5a2e05d2800a91cff08c2c73.jpeg","profile_background_image_url_https":"https:\/\/si0.twimg.com\/profile_background_images\/378800000116209016\/ff11dc9f5a2e05d2800a91cff08c2c73.jpeg","profile_background_tile":true,"profile_image_url":"http:\/\/pbs.twimg.com\/profile_images\/378800000736604157\/b6d36df6332a2cacb0d30b5328b668d6_normal.jpeg","profile_image_url_https":"https:\/\/pbs.twimg.com\/profile_images\/378800000736604157\/b6d36df6332a2cacb0d30b5328b668d6_normal.jpeg","profile_banner_url":"https:\/\/pbs.twimg.com\/profile_banners\/483470963\/1385144720","profile_link_color":"9D1DCF","profile_sidebar_border_color":"FFFFFF","profile_sidebar_fill_color":"E6F6F9","profile_text_color":"333333","profile_use_background_image":True,"default_profile":False,"default_profile_image":False,"following":null,"follow_request_sent":null,"notifications":null},"geo":null,"coordinates":null,"place":null,"contributors":null,"retweet_count":0,"favorite_count":0,"entities":{"hashtags":[],"symbols":[],"urls":[],"user_mentions":[]},"favorited":False,"retweeted":False,"filter_level":"medium","lang":"es"},
                  {"created_at":"Sun Dec 01 01:19:00 +0000 2013","id":12345,"id_str":"12345","text":"Todo va a estar bn :D","source":"\u003ca href=\"http:\/\/blackberry.com\/twitter\" rel=\"nofollow\"\u003eTwitter for BlackBerry\u00ae\u003c\/a\u003e","truncated":False,"in_reply_to_status_id":null,"in_reply_to_status_id_str":null,"in_reply_to_user_id":null,"in_reply_to_user_id_str":null,"in_reply_to_screen_name":null,"user":{"id":54321,"id_str":"54321","name":"xxxxx","screen_name":"xxxxx","location":"","url":null,"description":"No pretendo ser nadie mas y no soy perfecta lo se, tengo muchos errores tambi\u00e9n lo se pero me acepto y me amo como soy.","protected":false,"followers_count":71,"friends_count":64,"listed_count":0,"created_at":"Sun Feb 05 02:04:16 +0000 2012","favourites_count":218,"utc_offset":-21600,"time_zone":"Central Time (US & Canada)","geo_enabled":True,"verified":False,"statuses_count":10407,"lang":"es","contributors_enabled":False,"is_translator":False,"profile_background_color":"DBE9ED","profile_background_image_url":"http:\/\/a0.twimg.com\/profile_background_images\/378800000116209016\/ff11dc9f5a2e05d2800a91cff08c2c73.jpeg","profile_background_image_url_https":"https:\/\/si0.twimg.com\/profile_background_images\/378800000116209016\/ff11dc9f5a2e05d2800a91cff08c2c73.jpeg","profile_background_tile":true,"profile_image_url":"http:\/\/pbs.twimg.com\/profile_images\/378800000736604157\/b6d36df6332a2cacb0d30b5328b668d6_normal.jpeg","profile_image_url_https":"https:\/\/pbs.twimg.com\/profile_images\/378800000736604157\/b6d36df6332a2cacb0d30b5328b668d6_normal.jpeg","profile_banner_url":"https:\/\/pbs.twimg.com\/profile_banners\/483470963\/1385144720","profile_link_color":"9D1DCF","profile_sidebar_border_color":"FFFFFF","profile_sidebar_fill_color":"E6F6F9","profile_text_color":"333333","profile_use_background_image":True,"default_profile":False,"default_profile_image":False,"following":null,"follow_request_sent":null,"notifications":null},"geo":null,"coordinates":null,"place":null,"contributors":null,"retweet_count":0,"favorite_count":0,"entities":{"hashtags":[],"symbols":[],"urls":[],"user_mentions":[]},"favorited":False,"retweeted":False,"filter_level":"medium","lang":"es"},
                  {"created_at":"Sun Dec 01 01:19:00 +0000 2013","id":12345,"id_str":"12345","text":"Todo va a estar bn :D","source":"\u003ca href=\"http:\/\/blackberry.com\/twitter\" rel=\"nofollow\"\u003eTwitter for BlackBerry\u00ae\u003c\/a\u003e","truncated":False,"in_reply_to_status_id":null,"in_reply_to_status_id_str":null,"in_reply_to_user_id":null,"in_reply_to_user_id_str":null,"in_reply_to_screen_name":null,"user":{"id":54321,"id_str":"54321","name":"xxxxx","screen_name":"xxxxx","location":"","url":null,"description":"No pretendo ser nadie mas y no soy perfecta lo se, tengo muchos errores tambi\u00e9n lo se pero me acepto y me amo como soy.","protected":false,"followers_count":71,"friends_count":64,"listed_count":0,"created_at":"Sun Feb 05 02:04:16 +0000 2012","favourites_count":218,"utc_offset":-21600,"time_zone":"Central Time (US & Canada)","geo_enabled":True,"verified":False,"statuses_count":10407,"lang":"es","contributors_enabled":False,"is_translator":False,"profile_background_color":"DBE9ED","profile_background_image_url":"http:\/\/a0.twimg.com\/profile_background_images\/378800000116209016\/ff11dc9f5a2e05d2800a91cff08c2c73.jpeg","profile_background_image_url_https":"https:\/\/si0.twimg.com\/profile_background_images\/378800000116209016\/ff11dc9f5a2e05d2800a91cff08c2c73.jpeg","profile_background_tile":true,"profile_image_url":"http:\/\/pbs.twimg.com\/profile_images\/378800000736604157\/b6d36df6332a2cacb0d30b5328b668d6_normal.jpeg","profile_image_url_https":"https:\/\/pbs.twimg.com\/profile_images\/378800000736604157\/b6d36df6332a2cacb0d30b5328b668d6_normal.jpeg","profile_banner_url":"https:\/\/pbs.twimg.com\/profile_banners\/483470963\/1385144720","profile_link_color":"9D1DCF","profile_sidebar_border_color":"FFFFFF","profile_sidebar_fill_color":"E6F6F9","profile_text_color":"333333","profile_use_background_image":True,"default_profile":False,"default_profile_image":False,"following":null,"follow_request_sent":null,"notifications":null},"geo":null,"coordinates":null,"place":null,"contributors":null,"retweet_count":0,"favorite_count":0,"entities":{"hashtags":[],"symbols":[],"urls":[],"user_mentions":[]},"favorited":False,"retweeted":False,"filter_level":"medium","lang":"es"}]
          

          使用flatten_json:

          1. 如果datajson,如上所述
          1. if data is a json, as above

          df = pd.DataFrame([flatten_json(x) for x in data['stuff'])
          

          1. 如果datadictslist,如上所述
          1. if data is a list of dicts, as above

          df = pd.DataFrame([flatten_json(x) for x in data)
          

          输出:

                               created_at     id id_str                   text                                                                                  source  truncated in_reply_to_status_id in_reply_to_status_id_str in_reply_to_user_id in_reply_to_user_id_str in_reply_to_screen_name  user_id user_id_str user_name user_screen_name user_location user_url                                                                                                         user_description  user_protected  user_followers_count  user_friends_count  user_listed_count                 user_created_at  user_favourites_count  user_utc_offset              user_time_zone  user_geo_enabled  user_verified  user_statuses_count user_lang  user_contributors_enabled  user_is_translator user_profile_background_color                                                                            user_profile_background_image_url                                                                        user_profile_background_image_url_https  user_profile_background_tile                                                                                    user_profile_image_url                                                                               user_profile_image_url_https                                          user_profile_banner_url user_profile_link_color user_profile_sidebar_border_color user_profile_sidebar_fill_color user_profile_text_color  user_profile_use_background_image  user_default_profile  user_default_profile_image user_following user_follow_request_sent user_notifications   geo coordinates place contributors  retweet_count  favorite_count  favorited  retweeted filter_level lang
           Sun Dec 01 01:19:00 +0000 2013  12345  12345  Todo va a estar bn :D  <a href="http:\/\/blackberry.com\/twitter" rel="nofollow">Twitter for BlackBerry®<\/a>      False                  None                      None                None                    None                    None    54321       54321     xxxxx            xxxxx                   None  No pretendo ser nadie mas y no soy perfecta lo se, tengo muchos errores también lo se pero me acepto y me amo como soy.           False                    71                  64                  0  Sun Feb 05 02:04:16 +0000 2012                    218           -21600  Central Time (US & Canada)              True          False                10407        es                      False               False                        DBE9ED  http:\/\/a0.twimg.com\/profile_background_images\/378800000116209016\/ff11dc9f5a2e05d2800a91cff08c2c73.jpeg  https:\/\/si0.twimg.com\/profile_background_images\/378800000116209016\/ff11dc9f5a2e05d2800a91cff08c2c73.jpeg                          True  http:\/\/pbs.twimg.com\/profile_images\/378800000736604157\/b6d36df6332a2cacb0d30b5328b668d6_normal.jpeg  https:\/\/pbs.twimg.com\/profile_images\/378800000736604157\/b6d36df6332a2cacb0d30b5328b668d6_normal.jpeg  https:\/\/pbs.twimg.com\/profile_banners\/483470963\/1385144720                  9D1DCF                            FFFFFF                          E6F6F9                  333333                               True                 False                       False           None                     None               None  None        None  None         None              0               0      False      False       medium   es
           Sun Dec 01 01:19:00 +0000 2013  12345  12345  Todo va a estar bn :D  <a href="http:\/\/blackberry.com\/twitter" rel="nofollow">Twitter for BlackBerry®<\/a>      False                  None                      None                None                    None                    None    54321       54321     xxxxx            xxxxx                   None  No pretendo ser nadie mas y no soy perfecta lo se, tengo muchos errores también lo se pero me acepto y me amo como soy.           False                    71                  64                  0  Sun Feb 05 02:04:16 +0000 2012                    218           -21600  Central Time (US & Canada)              True          False                10407        es                      False               False                        DBE9ED  http:\/\/a0.twimg.com\/profile_background_images\/378800000116209016\/ff11dc9f5a2e05d2800a91cff08c2c73.jpeg  https:\/\/si0.twimg.com\/profile_background_images\/378800000116209016\/ff11dc9f5a2e05d2800a91cff08c2c73.jpeg                          True  http:\/\/pbs.twimg.com\/profile_images\/378800000736604157\/b6d36df6332a2cacb0d30b5328b668d6_normal.jpeg  https:\/\/pbs.twimg.com\/profile_images\/378800000736604157\/b6d36df6332a2cacb0d30b5328b668d6_normal.jpeg  https:\/\/pbs.twimg.com\/profile_banners\/483470963\/1385144720                  9D1DCF                            FFFFFF                          E6F6F9                  333333                               True                 False                       False           None                     None               None  None        None  None         None              0               0      False      False       medium   es
           Sun Dec 01 01:19:00 +0000 2013  12345  12345  Todo va a estar bn :D  <a href="http:\/\/blackberry.com\/twitter" rel="nofollow">Twitter for BlackBerry®<\/a>      False                  None                      None                None                    None                    None    54321       54321     xxxxx            xxxxx                   None  No pretendo ser nadie mas y no soy perfecta lo se, tengo muchos errores también lo se pero me acepto y me amo como soy.           False                    71                  64                  0  Sun Feb 05 02:04:16 +0000 2012                    218           -21600  Central Time (US & Canada)              True          False                10407        es                      False               False                        DBE9ED  http:\/\/a0.twimg.com\/profile_background_images\/378800000116209016\/ff11dc9f5a2e05d2800a91cff08c2c73.jpeg  https:\/\/si0.twimg.com\/profile_background_images\/378800000116209016\/ff11dc9f5a2e05d2800a91cff08c2c73.jpeg                          True  http:\/\/pbs.twimg.com\/profile_images\/378800000736604157\/b6d36df6332a2cacb0d30b5328b668d6_normal.jpeg  https:\/\/pbs.twimg.com\/profile_images\/378800000736604157\/b6d36df6332a2cacb0d30b5328b668d6_normal.jpeg  https:\/\/pbs.twimg.com\/profile_banners\/483470963\/1385144720                  9D1DCF                            FFFFFF                          E6F6F9                  333333                               True                 False                       False           None                     None               None  None        None  None         None              0               0      False      False       medium   es
          

          这篇关于处理 pandas 中的嵌套json的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆