如何从API返回的JSON中获取morePages字段的值

Let's walk through what's happening here:

First, when you run print(json_normalize(json_data["meta"])), the output shows a single-row DataFrame with columns currentPage, morePages, resultsPerPage and values 2, True, 2000. This tells us that json_data["meta"] is a dictionary (key-value pairs), not a list of dictionaries. That's why trying to access json_data["meta"][0] throws a KeyError: 0—there's no index 0 here, because it's not a list.

Correct Ways to Get the morePages Value: #

• Directly from the original JSON data (simplest method):

  print(json_data["meta"]["morePages"])
  

  This will directly return the boolean value True since you're accessing the "morePages" key in the meta dictionary.

• From the normalized DataFrame:
  If you already normalized the data and want to pull it from the DataFrame, first store the normalized result, then access the value by column name and row index:

  import pandas as pd
  df = pd.json_normalize(json_data["meta"])
  print(df["morePages"].iloc[0])  # Or use df.at[0, "morePages"]
  

The core issue was misassuming json_data["meta"] was a list (hence trying to use [0]), but it's actually a flat dictionary. Skip the index and go straight for the key name, and you'll get the value you need.

内容的提问来源于stack exchange，提问作者JSNoob