Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I have a dataframe called df. It includes a zip column (ie., includes zip codes) and I want to use the pyzipcodes library to create

I have a dataframe called df. It includes a zip column (ie., includes zip codes) and I want to use the pyzipcodes library to create a new column called state, and map the zip codes to states. The following code works in mapping zip codes to the state column, HOWEVER, it gives me a long list of string which includes zip code, city, state, etc. I only want state to show up. Please tell me how to correct this issue. Thank you df['zip code'] = df['zip code'].astype('object') df['state'] = df['zip code'].map(zcdb)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Machine Learning And Knowledge Discovery In Databases European Conference Ecml Pkdd 2015 Porto Portugal September 7 11 2015 Proceedings Part 3 Lnai 9286

Authors: Albert Bifet ,Michael May ,Bianca Zadrozny ,Ricard Gavalda ,Dino Pedreschi ,Francesco Bonchi ,Jaime Cardoso ,Myra Spiliopoulou

1st Edition

3319234609, 978-3319234601

More Books

Students also viewed these Databases questions

Question

What advice would you provide to Jennifer?

Answered: 1 week ago

Question

What are the issues of concern for each of the affected parties?

Answered: 1 week ago