(Questions 1-3 pertain to the video lecture “Exploring the Relational Data Model of CSV”)
What is the approximate population of La Paz county in the state of Arizona for the CENSUS2010POP (column H)? (Choose the best answer.)
At 2:45 of the video, the Instructor creates a filter for all of the counties in California with a population greater than 1,000,000. However, included in the results is the entire state of California. This anomalous value might skew our analysis if, for example, we wanted to compute the average population of these results. What additional filter might work to resolve this problem?
(Questions 8 and 9 pertain to the video lecture “Exploring the Semistructured Data Model of JSON”)
Given a tweet, what path would you most likely enter to obtain a count of the number of followers for a user?