Search code examples
pythonstringpython-requestsint

How to Delete stuff in a txt using python and keep certain ones left in txt


So for what I want to do I just want to delete some specific things I have in my file so, for example, I have this

json_str = '{"previousPageCursor":null,"nextPageCursor":"23971776_1_0c424f10e6a8a73392287b04ef20267c","data":[{"buildersClubMembershipType":"None","userId":29661084,"username":"HeartlessGod","displayName":"HeartlessGod"},{"buildersClubMembershipType":"None","userId":2736666,"username":"thunderbolt777","displayName":"thunderbolt777"},{"buildersClubMembershipType":"None","userId":9509309,"username":"FlyScript","displayName":"FlyScript"},{"buildersClubMembershipType":"None","userId":9933671,"username":"XcRaZeD","displayName":"XcRaZeD"},{"buildersClubMembershipType":"None","userId":1484736,"username":"dodo212","displayName":"dodo212"},{"buildersClubMembershipType":"None","userId":10026270,"username":"wassup99","displayName":"wassup99"},{"buildersClubMembershipType":"None","userId":559756,"username":"jack593","displayName":"jack593"},{"buildersClubMembershipType":"None","userId":6160107,"username":"spectacularmario","displayName":"spectacularmario"},{"buildersClubMembershipType":"None","userId":7706434,"username":"dustyscoobydoo","displayName":"dustyscoobydoo"},{"buildersClubMembershipType":"None","userId":1335986,"username":"dooter","displayName":"dooter"}]}'

And all I want to do is keep the numbers I have circled and delete all the other ones and put them in a row on top of each other


Solution

  • You can parser the Json with json module, for example:

    json_data = '''
        {"previousPageCursor":null,"nextPageCursor":"23971776_1_0c424f10e6a8a73392287b04ef20267c","data":[{"buildersClubMembershipType":"None","userId":29661084,"username":"HeartlessGod","displayName":"HeartlessGod"},{"buildersClubMembershipType":"None","userId":2736666,"username":"thunderbolt777","displayName":"thunderbolt777"},{"buildersClubMembershipType":"None","userId":9509309,"username":"FlyScript","displayName":"FlyScript"},{"buildersClubMembershipType":"None","userId":9933671,"username":"XcRaZeD","displayName":"XcRaZeD"},{"buildersClubMembershipType":"None","userId":1484736,"username":"dodo212","displayName":"dodo212"},{"buildersClubMembershipType":"None","userId":10026270,"username":"wassup99","displayName":"wassup99"},{"buildersClubMembershipType":"None","userId":559756,"username":"jack593","displayName":"jack593"},{"buildersClubMembershipType":"None","userId":6160107,"username":"spectacularmario","displayName":"spectacularmario"},{"buildersClubMembershipType":"None","userId":7706434,"username":"dustyscoobydoo","displayName":"dustyscoobydoo"},{"buildersClubMembershipType":"None","userId":1335986,"username":"dooter","displayName":"dooter"}]}
    '''
    
    import json
    
    parsed_data = json.loads(json_data)
    
    for d in parsed_data['data']:
        print(d['userId'])
    

    Prints:

    29661084
    2736666
    9509309
    9933671
    1484736
    10026270
    559756
    6160107
    7706434
    1335986
    

    You probably received this data from requests.get() or requests.post(), you can get the data with this call:

    parsed_data = requests.get(... URL HERE ...).json()