0

My goal is to create a dataframe based on the 'viewCount', 'likeCount', 'favoriteCount' and 'commentCount'.

The code below works gives 25 values for 'viewCount', 'favoriteCount', and 'commentCount', but I get an error for 'likeCount' because 'likeCount' has 1 missing value in its list.

How can I create an "if, then statement" that will place a 0 count into the 'likeCount' list when the programs see's that value doesn't exist.

The if then statement below is what I've tried, but I'm getting a KeyError: 'likeCount' error

x=0
y=0
viewCount = []
likeCount = []
favoriteCount = []
commentCount = []

while (x < len(response2)):
    viewCount.append(response2[x]['items'][0]['statistics']['viewCount'])
    favoriteCount.append(response2[x]['items'][0]['statistics']['favoriteCount'])
    commentCount.append(response2[x]['items'][0]['statistics']['commentCount'])
    if not (response2[x]['items'][0]['statistics']['likeCount']):
        likeCount.append(0) 
    else:
        likeCount.append(response2[x]['items'][0]['statistics']['likeCount'])
    x=x+1
    
            
#print(video_title, video_id)
df2 = pd.DataFrame({'viewCount': viewCount,'favoriteCount': favoriteCount,
            'commentCount': commentCount, 'likeCount' : likeCount} )
df2

ERROR MESSAGE:

KeyError                                  Traceback (most recent call last)

     10     favoriteCount.append(response2[x]['items'][0]['statistics']['favoriteCount'])
     11     commentCount.append(response2[x]['items'][0]['statistics']['commentCount'])
---> 12     if not (response2[x]['items'][0]['statistics']['likeCount']):
     13         likeCount.append(0)
     14     else:

KeyError: 'likeCount'
Trying to Learn Javascript
  • 343
  • 3
  • 13

2 Answers2

1

It appears that response2 doesn't have right key-value pair. Maybe you could try using a controlled exception.

For example:

try:
    likeCount.append(response2[x]['items'][0]['statistics']['likeCount'])
except:
    likeCount.append(0)

Also, I would strongly suggest using snake_case instead of camelCase for naming variables. In python generally snake_case is used for functions and variables, while camelCase is reserved for classes.

Hopefully my answer helped you.

Tomás Rivera H.
  • 66
  • 3
  • Good callout with the snake vs camel case. – Connor O'Leary Jan 20 '22 at 19:53
  • Copied, pasted, and it worked right away. except is acting as an exception? It works great, thank you! – Trying to Learn Javascript Jan 20 '22 at 20:01
  • Whenever you use try-except if there's an error inside the `try:` python handles it so that your program doesn't crash. Then it runs the code inside the `except:` and afterwards it continues with execution. You could also catch the exception and work with it by using except as follows `except Exception as e:` – Tomás Rivera H. Jan 20 '22 at 20:12
1

It is hard to be certain, but you are likely getting the error because using ['likeCount'] assumes that index is present in the object. Here is a different write:

    if not (response2[x]['items'][0]['statistics']['likeCount']):
        likeCount.append(0) 
    else:
        likeCount.append(response2[x]['items'][0]['statistics']['likeCount'])

so that it should work:

    likeCount.append(response2[x]['items'][0]['statistics'].get('likeCount', 0))

This utilizes the get function (which won't error if the index is not found) and sets the default value to 0.

Connor O'Leary
  • 106
  • 5