r - How to aggregate data by factor variables and count column -


i have data frame of factor variables columns , 1 numeric column , 1 integer column. want aggregate data unique factor variable combinations , sum counts. aggregate unique factor combi's doesn't sum count column.

data dataframe test2

        afdeling_1         probleemgebied               locatie.niveau.1            risico count    cost 1  secondairy assembly complete transformator         secundaire installatie  risico 3 ( hoog)     1      na 2          active part             binnenwerk                    actief deel  risico 3 ( hoog)     1      na 3         construction complete transformator         secundaire installatie risico 2 (midden)     1      na 4       final assembly          complete kast         complete transformator  risico 3 ( hoog)     1      na 5          windingshop              wikkeling                      wikkeling  risico 3 ( hoog)     1      na 6            warehouse complete transformator niet transformator gerelateerd   risico 1 (laag)     1      na 7          active part         wikkelingenset                 wikkelingenset   risico 1 (laag)     1      na 8            warehouse complete transformator         secundaire installatie risico 2 (midden)     1      na 9         pre assembly          complete kast  kastbodem (altijd onderzijde) risico 2 (midden)     1      na 10        pre assembly          complete kast  kastbodem (altijd onderzijde) risico 2 (midden)     1      na 11      final assembly complete transformator                    conservator  risico 3 ( hoog)     1      na 12      final assembly complete transformator         complete transformator  risico 3 ( hoog)     1      na 13        pre assembly          complete kast                    leidingwerk risico 2 (midden)     1      na 14                 kam             binnenwerk                    actief deel   risico 1 (laag)     1      na 15      final assembly          complete kast         complete transformator  risico 3 ( hoog)     1      na 16        pre assembly          complete kast                        koeling risico 2 (midden)     1      na 17                 kam         wikkelingenset                 wikkelingenset   risico 1 (laag)     1      na 18      final assembly             binnenwerk                    actief deel  risico 3 ( hoog)     1      na 19         active part         wikkelingenset                 wikkelingenset   risico 1 (laag)     1      na 20         active part         wikkelingenset                 wikkelingenset  risico 3 ( hoog)     1      na 21         active part             binnenwerk                    actief deel  risico 3 ( hoog)     1      na 22 secondairy assembly complete transformator         secundaire installatie  risico 3 ( hoog)     1      na 23                 kam          complete kast                        koeling risico 2 (midden)     1      na 24      final assembly          complete kast                       kastwand   risico 1 (laag)     1      na 25        pre assembly          complete kast  kastbodem (altijd onderzijde)  risico 3 ( hoog)     1      na 26        construction             binnenwerk                    actief deel   risico 1 (laag)     1      na 27      final assembly complete transformator niet transformator gerelateerd  risico 3 ( hoog)     1      na 28      final assembly             binnenwerk                    actief deel   risico 1 (laag)     1      na 29      spoelenmontage         wikkelingenset                 wikkelingenset   risico 1 (laag)     1      na 30         active part                   kern                           kern  risico 3 ( hoog)     1 1820.00 31         active part                   kern                           kern   risico 1 (laag)     1      na 32         windingshop              wikkeling                      wikkeling risico 2 (midden)     1      na 33      final assembly complete transformator                       kastwand  risico 3 ( hoog)     1      na 34         active part         wikkelingenset                 wikkelingenset risico 2 (midden)     1 1407.36 35         active part         wikkelingenset                 wikkelingenset   risico 1 (laag)     1      na 36         active part         wikkelingenset                 wikkelingenset   risico 1 (laag)     1      na 37 secondairy assembly complete transformator         secundaire installatie  risico 3 ( hoog)     1      na 38           warehouse complete transformator niet transformator gerelateerd risico 2 (midden)     1      na 39           warehouse complete transformator                       kastwand risico 2 (midden)     1      na 40      final assembly          complete kast  kastbodem (altijd onderzijde)  risico 3 ( hoog)     1      na 41           warehouse complete transformator niet transformator gerelateerd  risico 3 ( hoog)     1      na 42           warehouse complete transformator niet transformator gerelateerd  risico 3 ( hoog)     1      na 43      spoelenmontage              wikkeling                      wikkeling   risico 1 (laag)     1      na 44    sales & projects complete transformator         complete transformator  risico 3 ( hoog)     1      na 45         active part             binnenwerk                    actief deel   risico 1 (laag)     1      na 46                 kam complete transformator         complete transformator risico 2 (midden)     1      na 47         windingshop              wikkeling                      wikkeling   risico 1 (laag)     1      na 48    sales & projects complete transformator         complete transformator   risico 1 (laag)     1      na 49         active part             binnenwerk                    actief deel   risico 1 (laag)     1      na 50        pre assembly          complete kast                        koeling  risico 3 ( hoog)     1      na

this code used:

aggregate(count ~., test2, sum)

this result get:

  afdeling_1 probleemgebied locatie.niveau.1            risico    cost count 1 active part wikkelingenset   wikkelingenset risico 2 (midden) 1407.36     1 2 active part           kern             kern  risico 3 ( hoog) 1820.00     1

i see underlying problem not aggregate doesn't work, cost column has na's , data aggregated records cost. need way nas not omitted.


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