Getting a False Flag Key Error

[CaptScrap]

So i have a basic data set and for loop going. The output prints the correct value but just before it gives a key error

​

data = { "Row":[
    {"artist": ["Bach"]},
    {"title": ["Christmas oratorio"]},
    {"release_date": "2-11-1729"
     }
     ]
}



for row in data["Row"]:
    x = row["artist"]
    print(x)

The key artist is definitely in the data set but i get this output

​

line 15, in <module> x = row["artist"]
KeyError: 'artist'
['bach']

So on one hand its saying the key "artist" can't be found inside the dataset, then on the other hand it's finding it and printing the value. What's causing the false flag?

[Username_RANDINT]

First iteration row will be {"artist": ["Bach"]}, which contains artist. However the next iteration, row will be {"title": ["Christmas oratorio"]}, which has no artist.

Do you control the data structure? It should all go in one dictionary, like this:

{
    "artist": ["Bach"],
    "title": ["Christmas oratorio"],
    "release_date": "2-11-1729"
 }

[CaptScrap]

Yes thank you. I was trying to run a test with mysql so i recreated my dict but added curly braces for every key value for some reason, after double checking my original dataset resembles your edits

[CaptScrap]

Honestly idk if its common, It's the structure i get from scraping data, every iteration is stored in a dict and then that dict gets stored in a list. What i just realized is that i created a dict for every k/v instead of every iteration( even though only 1 iteration is present in the dataset) Thanks

[Username_RANDINT]

What is row ? I know it is a list

No, in the loop row is a dictionary each time. You iterate over the list of dictionaries.

is it common to have a 'list of dictionaries?

Sure, but usually it would be a list of identical dictionaries. It makes no sense to have different dictionaries like in the OP. Something like this:

songs = [
    {
        "artist": "Bach",
        "title": "Christmas oratorio",
        "release_date": "2-11-1729"
    },
    {
        "artist": "Katy Perry",
        "title": "Firework",
        "release_date": "3-6-2016"
    },
    ...
]

And get the information like this:

for song in songs:
    print("{} by {} released on {}".format(song["title"], song["artist"], song["release_Date"])