aws-user-list-json-to-dataframe.py

gistfile1.txt

import pandas as pd
import json
from pandas import json_normalize

with open('aws-users.json', 'r', encoding = 'utf-16') as file:
    data = file.read().replace('\n', '')

dict = json.loads(data)
df2 = json_normalize(dict['Users']) 

print(df2.head())
""""
Example Data
{
    "Users": [
        {
            "Path": "/",
            "UserName": "john.doe@example.com",
            "UserId": "user-id",
            "Arn": "arn:aws:iam::....",
            "CreateDate": "2018-07-10T09:30:51+00:00",
            "PasswordLastUsed": "2021-06-21T07:42:36+00:00"
        },
        {
            "Path": "/",
            "UserName": "john.doe2@example.com",
            "UserId": "user-id",
            "Arn": "arn:aws:iam::....",
            "CreateDate": "2022-05-30T06:06:07+00:00",
            "PasswordLastUsed": "2022-09-01T21:17:43+00:00"
        }
    ]
}
"""