Can someone help me figure this out in Python?
The movie company has hired you to help them enhance their data set. They would like to know which US State each of the respondents in their movie goers survey comes from, and ask you to produce a list of states and a count of movie goers from that state. The movie goers dataset NYC1 – moviegoers.csv from NYC1 contains ‘zip_code’ but not city and state. We will load another pandas dataset, the Zipcode Database here This data set contains Zip codes with primary city, state and approximate location. Your goal is to figure out how to use the DataFrame.merge() method to combine these two data sets on matching zip code values. After you merge the dataset, then you can complete the task and provide a count of movie goers by state.