How can I flatten JSON data in Python?

How can I flatten JSON data in Python?

You can use libraries like pandas or json_normalize from pandas to flatten JSON data. Would you like an example?

Yes, please provide an example using json_normalize.

Sure! Here's a simple example:

import pandas as pd

# Sample JSON data
json_data = [
    {'id': 1, 'name': 'John', 'address': {'city': 'New York', 'state': 'NY'}},
    {'id': 2, 'name': 'Jane', 'address': {'city': 'Los Angeles', 'state': 'CA'}}
]

# Flattening the JSON data
flat_data = pd.json_normalize(json_data)
print(flat_data)

This will give you a flat DataFrame with columns for id, name, address.city, and address.state.

What if my JSON data has nested arrays?

In that case, you might need to use a more complex approach, possibly involving custom functions to handle the nested arrays. Would you like to explore that?