python - Handle multiple values in column -


consider example data.table package in r:

dt = data.table(id = c("b","b","b","a","a","c"), = 1:6, b = 7:12, c=13:18) dt = dt[, .(a=list(a), b=list(b), c=list(c)), by=id] dt    id         b        c 1:  b 1,2,3 7,8,9 13,14,15 2:    4,5 10,11    16,17 3:  c     6    12       18

after want write file in order share structure. however, prohibits writing such things write.csv because of list type. solution found convert columns string. however, how can read file? there unified format can read in (almost) language without effort?

you can create tab-seperated file follows:

dt2 <- dt[, .(a=tostring(a), b=tostring(b), c=tostring(c)), by=id] write.table(dt2, "dt2.txt", sep="\t", row.names = false)

which should readable languages.

when want preserve lists, transforming json suggested @tigerhawkt3 best option:

dt3 <- dt[, .(a=list(a), b=list(b), c=list(c)), by=id] library(jsonlite) tojson(dt3)

which gives:

[{"id":"b","a":[1,2,3],"b":[7,8,9],"c":[13,14,15]},{"id":"a","a":[4,5],"b":[10,11],"c":[16,17]},{"id":"c","a":[6],"b":[12],"c":[18]}]

Comments

Post a Comment

Popular posts from this blog

authentication - Mongodb revoke acccess to connect test database -

i have ec2 instance mongodb 3.2.0 installed. have user admin access. can connect user , perform operation remotely. 1 can connect database test remote if knows ip mongo 11.11.11.11. although not able make operations, want restrict access user credentials can connect server. first need create users , grant roles users, example: use admin db.createuser( { user: "myuseradmin", pwd: "abc123", roles: [ { role: "useradminanydatabase", db: "admin" } ] } ) then need start server --auth parameter mongod --auth more information here
Read more

python - GitPython: check if git is available -

gitpython depends on having command line version of git installed (otherwise, issue in question: oserror: [errno 2] no such file or directory on gitpython ). is there way gitpython api check if executable found, or, need wrap gitpython calls in exception handling account possibility? i don't particularly recommend this, did @ least once: try 1 git command while catching oserror case see if can run git (and running it, capture git version number well, in case). if git fails run, complain , disable further invocations of git (or exit or whatever). if not, assume further invocations continue work.
Read more

c - getting error: cannot take the address of an rvalue of type 'int' -

i tryed compile old code new compiler , got next error: error: cannot take address of rvalue of type 'int' here example 2 lines - 1 compiles , other gives error struct mstct { int myfield; int myfield2[5]; int myfield3[5]; }; typedef struct mstct db_data_px; int foo(int a, int b, int c){ //the next code compiles successfully. unsigned val1 = ((18 == c) ? ((unsigned) & (((db_data_px *) 0)->myfield)) : ((unsigned) & (((db_data_px *) 0)->myfield3[b]))); //successes //the next code failing unsigned val2 = (unsigned) & ((18 == c) ? (((db_data_px *) 0)->myfield) : (((db_data_px *) 0)->myfield3[b])); return 0; // failing } why first line compiles , second failing ? why need cast (unsigned) & in both of select expression , not enough cast after select expression valued ? in code ((18 == c) ? (((db_data_px *) 0)->myfield) : (((db_data_px *) 0)->myfield3[b])) is conditional expression not produce lva...
Read more