Question

A SOC analyst has a Python script that queries a threat-intel API and prints each indicator's value and reputation score to the console. The team lead asks the analyst to modify the script so the results are saved to a file named 'indicators.csv' with a header row, so the data can be opened in a spreadsheet and shared. The current relevant code is:

```python
import requests
resp = requests.get(url, headers=headers)
for item in resp.json()['data']:
    print(item['indicator'], item['score'])
```

Which modification correctly produces the required CSV output?

Accepted Answer

import csv
with open('indicators.csv', 'w', newline='') as f:
    writer = csv.writer(f)
    writer.writerow(['indicator', 'score'])
    for item in resp.json()['data']:
        writer.writerow([item['indicator'], item['score']])

Answer

import json
with open('indicators.csv', 'w') as f:
    json.dump(resp.json()['data'], f)

Answer

for item in resp.json()['data']:
    print(item['indicator'], item['score'], file='indicators.csv')

Answer

with open('indicators.csv', 'r') as f:
    for item in resp.json()['data']:
        f.write(item['indicator'] + ',' + item['score'])