extract data from json file using python

Question

I have this json file.

{
  "entityId": "PROCESS_1234",
  "displayName": "Windows System",
  "firstSeenTms": 1619147697131,
  "lastSeenTms": 1653317760000,
  "properties": {
    "detectedName": "Windows System",
    "bitness": "32",
    "metadata": [],
    "awsNameTag": "Windows System",
    "softwareTechnologies": [
      {
        "type": "WINDOWS_SYSTEM"
      }
    ],
    "processType": "WINDOWS_SYSTEM"
    
    
  }
  
}

I need to extract entityId": "PROCESS_1234" and "properties": { "detectedName": "Windows System" as a data frame. The data frame needs to look like this:

entityId        detectedName
PROCESS_1234    Windows System

I have tried this:

print(resp2['entityId']['properties'][0]['detectedName'])

I get this error:

---------------------------------------------------------------------------
TypeError                                 Traceback (most recent call last)
<ipython-input-6-09b87f04b95e> in <module>
----> 1 print(resp2['entityId']['properties'][0]['detectedName'])

TypeError: string indices must be integers

If you select entityId, the value is now "PROCESS_1234" so when you select "property" it is not valid for strings — Fed_Dragon
– Fed_Dragon, Commented May 23, 2022 at 17:05

Avinash · Accepted Answer · 2022-05-23 17:06:50Z

2

To extract entityId, do:

print(resp2['entityId'])

To extract detectedName, do:

print(resp2['properties']['detectedName'])

answered May 23, 2022 at 17:06

Avinash

8758 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

user1471980 Over a year ago

print needs to print out entityId and detectedName in one line not different print statements

Avinash Over a year ago

@user1471980 Do print(resp2['entityId'], resp2['properties']['detectedName'])

Jahan Zabe · Accepted Answer · 2022-05-23 17:08:57Z

0

this error occur when you pass a string value

print(resp2[0][1]) try like this.

answered May 23, 2022 at 17:08

Jahan Zabe

491 silver badge5 bronze badges

Comments

Gabriel Pellegrino · Accepted Answer · 2022-05-23 17:11:05Z

0

The program

import pandas as pd
data = {
  "entityId": "PROCESS_1234",
  "displayName": "Windows System",
  "firstSeenTms": 1619147697131,
  "lastSeenTms": 1653317760000,
  "properties": {
    "detectedName": "Windows System",
    "bitness": "32",
    "metadata": [],
    "awsNameTag": "Windows System",
    "softwareTechnologies": [
      {
        "type": "WINDOWS_SYSTEM"
      }
    ],
    "processType": "WINDOWS_SYSTEM"
  }
}

rows = [(data['entityId'], data['properties']['detectedName'])]
x = pd.DataFrame(data=rows, columns=['entityId', 'detectedName'])
print(x)

The output

bash-5.1$ python3 c.py
       entityId    detectedName
0  PROCESS_1234  Windows System

answered May 23, 2022 at 17:11

Gabriel Pellegrino

1,1221 gold badge8 silver badges17 bronze badges

Collectives™ on Stack Overflow

extract data from json file using python

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related