python 2.7 - Hierarchical index in data frame missing columns -

-

im trying learn pandas doing different exercises. created dataframe looks example below. i'm trying create unique id concatenating fields, when data frame columns have fpd column. explain me why don't see columns? 

monthid  pollutantid  processid  roadtypeid  avgspeedbinid     fpd 1        1            1          4           1                1.749101                                              2                0.935300                                              3                0.529701                                              4                0.393052                                              5                0.306381                                              6                0.261649                                              7                0.235040

i data frame executing this: 

fpd =    data['fpd'].groupby([data['monthid'],data['pollutantid'],          data['processid'],data['roadtypeid'],data['avgspeedbinid']]).sum()  fp = pd.dataframe(fpd)

you reset multiindex columns by: 

fp.reset_index(inplace=true)

Comments

Post a Comment

Popular posts from this blog

c# - HttpResponseMessage System.InvalidOperationException -

-
quite simple problem i've got easy solve reckon brains. it's tried different queries on google , nothing popped hey that's why here. here error: system.invalidoperationexception basically error thrown on piece of code here string test = response.content.headers.getvalues("location").firstordefault(); location in fiddler looks this: location: https://www.redirecturlishere.com/blah here entire function: private async task<string> getrequest() { //httpcontent postcontent = new stringcontent(post, encoding.ascii, "application/x-www-form-urlencoded"); using (httpresponsemessage response = await httpclient.getasync( "http://www.cant-share-url.com")) { using (httpcontent content = response.content) { string test = response.content.headers.getvalues("location").firstordefault(); } } return ""; ...
Read more

sql - Postgresql error: "failed to find conversion function from unknown to text" -

-
i have following postgresql query: ( select '201405mase04' testid, count(*) totq, count(distinct case when se1 = '' null else se1 end) totse, case when count(*)=0 7 else count(distinct rc) end totrc eivtestitems ti, eivtests t ti.test_id = t.test_id , t.test_type_id = 1 , t.test_id= '201405mase04' , ti.omit <> 1 ), b ( select '201405mase04' testid, count(*) totq eivtestitems ti, eivtests t ti.test_id = t.test_id , t.test_type_id = 1 , t.test_id= '201405mase04' , ti.omit = 1 ), c ( select '201405mase04' testid, count(*) totq eivtestitems ti, eivtests t ti.test_id = t.test_id , t.test_type_id = 1 , t.test_id= '201405mase04' , ti....
Read more