pandas - Count number of counties per state using python {census} -


i troubling counting number of counties using famous cenus.csv data.

task: count number of counties in each state.

facing comparing (i think) / please read below?

i've tried this:

df = pd.read_csv('census.csv') dfd = df[:]['stname'].unique()  //gives out names of state  serr = pd.series(dfd)  // converting series (from array)

after this, i've tried using 2 approaches:

1:

    df[df['stname'] == serr] **//error: series length must match**

2: 

i = 0 name in serr:                        //this generate error 'alabama'     df['stname'] == name     in serr:         serr[i] == serr[name]         print(serr[name].count)         i+=1

please guide me; has been 3 days stuff.

use groupby , aggregate county using nunique:

in [1]: import pandas pd  in [2]: df = pd.read_csv('census.csv')  in [3]: unique_counties = df.groupby('stname')['county'].nunique()

now results

in [4]: unique_counties out[4]:  stname alabama                  68 alaska                   30 arizona                  16 arkansas                 76 california               59 colorado                 65 connecticut               9 delaware                  4 district of columbia      2 florida                  68 georgia                 160 hawaii                    6 idaho                    45 illinois                103 indiana                  93 iowa                    100 kansas                  106 kentucky                121 louisiana                65 maine                    17 maryland                 25 massachusetts            15 michigan                 84 minnesota                88 mississippi              83 missouri                116 montana                  57 nebraska                 94 nevada                   18 new hampshire            11 new jersey               22 new mexico               34 new york                 63 north carolina          101 north dakota             54 ohio                     89 oklahoma                 78 oregon                   37 pennsylvania             68 rhode island              6 south carolina           47 south dakota             67 tennessee                96 texas                   255 utah                     30 vermont                  15 virginia                134 washington               40 west virginia            56 wisconsin                73 wyoming                  24 name: county, dtype: int64

Comments

Post a Comment

Popular posts from this blog

asynchronous - C# WinSCP .NET assembly: How to upload multiple files asynchronously -

i using winscp .net assembly uploading files. want upload multiple files asynchronous way. have created method works single upload. public class uploadingdata { private sessionoptions _sessionoptions; private session _session; //connection etc private void onconnected() { foreach (var fileinfo in localfileslist) { var task = task.factory.startnew(() => uploadfilesasync(fileinfo)); } } private async task uploadfilesasync(string file) { string remotefilepath = _session.translatelocalpathtoremote(file, @"/", "/test_data_upload"); var uploading = _session.putfiles(file, remotefilepath, false); //when done await task.run(() => thread.sleep(1000)); } } please suggest me correct way. thanks you can use backgroundworker class this: string[] images = new string[50]; foreach (var path in images) { backgroundworker
Read more

aws api gateway - SerializationException in posting new Records via Dynamodb Proxy Service in API -

i getting "__type": "com.amazon.coral.service#serializationexception" as reply in postman & in test console in api gateway trying post record directly dynamodb using api proxy services.. referring aws article - https://aws.amazon.com/blogs/compute/using-amazon-api-gateway-as-a-proxy-for-dynamodb/ here's mapping { "tablename": "tablenamegoeshere", "item": { "id" : "$context.requestid" "eventname" : "$input.path('$.eventname')", "timestamp" : $input.path('$.timestamp'), "answers": "$util.parsejson($input.path('$.answers'))" } } update: did asked ... , worked if try add array of json objects gives me above same error - here's trying now. please - couldnt find on google well #set($inputroot = $input.path('$')) { "tablename": "answer", "item": {
Read more

asp.net - Problems sending emails from forum -

i have been redesigning site has message board, has been written guy looked after site. it has few problems , written in .asp , uses .mdb files database. you can see whole thing here . feel free post if helps, test thing have set using original files , new database. the basic problem when posts message, supposed email sent them, have posted it. when replies, originator supposed message, replier has been posted. i’d have thought @ point in process there should script/file in postmessage.asp? the postmessage.asp page below. <% option explicit %> <!-- #include virtual="common/adovbs.inc" --> <html> <head> <meta http-equiv="content-type" content="text/html; charset=windows-1252"> <meta name="generator" content="microsoft frontpage 4.0"> <meta name="progid" content="frontpage.editor.document"> <title>new page 2</title> <base target="_self"
Read more