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
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()