过滤并可视化从表中选择键和值

Question

我只想显示感兴趣的键及其关联值。此外，None表示不适用。我还希望将键大写或替换为lastUpdateEt，使其最后更新为或替换为total，使其经过total测试

import requests
import json
import pandas as pd


state = input("Enter two character state code eg: NY, CA: ")
url = "https://covidtracking.com/api/states?state={}".format(state)

result = requests.get(url)
dataobj = result.json()

# Only intersted in showing these keys and their associated values:
# interested_keys['state','positive','grade','negative','pending','hospitalized','death','total','lastUpdateEt']


df = pd.DataFrame.from_dict(dataobj, orient='index',columns=['Values'])
df