r - Unlisting columns by groups -


i have dataframe in following format:

id | name               | logs                                   ---+--------------------+----------------------------------------- 84 |          "zibaroo" |                             "c47931038"  12 | "fabien kelyarsky" | c("c47331040", "b19412225", "b18511449") 96 |     "mitra lutsko" |              c("f19712226", "a18311450") 34 |       "paulsandoz" |                             "a47431044"  65 |       "beamvision" |                             "d47531045"

as see column "logs" includes vectors of strings in each cell.

is there efficient way convert data frame long format (one observation per row) without intermediary step of separating "logs" several columns?

this important because dataset large , number of logs per person seems arbitrary.

in other words, need following:

id | name               | log                                  ---+--------------------+------------ 84 |          "zibaroo" | "c47931038"  12 | "fabien kelyarsky" | "c47331040" 12 | "fabien kelyarsky" | "b19412225" 12 | "fabien kelyarsky" | "b18511449" 96 |     "mitra lutsko" | "f19712226" 96 |     "mitra lutsko" | "a18311450" 34 |       "paulsandoz" | "a47431044"  65 |       "beamvision" | "d47531045"

here dput of section of real dataframe:

structure(list(id = 148:157, name = c("avihil1", "niarfe", "doug henderson",  "nick tan", "madisp", "woodbusy", "kevinhcross", "cylol", "andrewarrow",  "gstavrev"), logs = list("z47331572", "z47031573", c("f47531574",  "b195945", "d186871", "s192939", "s182865", "g19539045"), c("a47231575",  "a190933", "c181859"), "f47431576", c("b47231577", "d193936",  "q184862"), "y47331579", c("a47531580", "z195944", "b185870"),  "n47731581", "e47231582")), .names = c("id", "name", "logs" ), row.names = 149:158, class = "data.frame")

this perfect case tidyr:

library(tidyr) library(dplyr) dat %>% unnest(logs)

-

Comments

Post a Comment

Popular posts from this blog

java - UnknownEntityTypeException: Unable to locate persister (Hibernate 5.0) -

Image
in code below when try execute main.java getting exception: exception in thread "main" org.hibernate.unknownentitytypeexception: unable locate persister: com.np.vta.test.pojo.users @ org.hibernate.internal.sessionfactoryimpl.locateentitypersister(sessionfactoryimpl.java:792) @ org.hibernate.internal.sessionimpl.locateentitypersister(sessionimpl.java:2637) @ org.hibernate.internal.sessionimpl.access$2500(sessionimpl.java:164) @ org.hibernate.internal.sessionimpl$identifierloadaccessimpl.<init>(sessionimpl.java:2575) @ org.hibernate.internal.sessionimpl$identifierloadaccessimpl.<init>(sessionimpl.java:2562) @ org.hibernate.internal.sessionimpl.byid(sessionimpl.java:1044) @ org.hibernate.internal.sessionimpl.get(sessionimpl.java:955) @ com.app.test.main.main(main.java:20) but if uncomment cfg.addclass( users.class ).addresource( "com/np/vta/test/pojo/users.hbm.xml" ); code works fine. why not reading <mapping...
Read more

python - ValueError: empty vocabulary; perhaps the documents only contain stop words -

i'm using (for first time) scikit library , got error: valueerror: empty vocabulary; perhaps documents contain stop words file "c:\users\a605563\desktop\velibprojetpreso\traitementtwitterdico.py", line 33, in <module> x_train_counts = count_vect.fit_transform(filetweets) file "c:\python27\lib\site-packages\sklearn\feature_extraction\text.py", line 804, in fit_transform self.fixed_vocabulary_) file "c:\python27\lib\site-packages\sklearn\feature_extraction\text.py", line 751, in _count_vocab raise valueerror("empty vocabulary; perhaps documents contain stop words but don't understand why that's happening. import sklearn sklearn.feature_extraction.text import countvectorizer import pandas pd import numpy import unicodedata import nltk tweetsfile = open('tweets2015-08-13.csv', 'r+') f2 = open('analyzer.txt', 'a') print tweetsfile.readline() count_vect = countvectorizer(strip_accents='ascii...
Read more

ubuntu - collect2: fatal error: ld terminated with signal 9 [Killed] -

Image
i'm trying build precimonious on ubuntu 16.04.3 x64. allocated 1gb memory it. file structure looks like ~ |--- llvm/ |--- precimonious/ where llvm on version 3.0 mentioned @ https://github.com/corvette-berkeley/precimonious#requirement . followed steps on readme command make ended with ... llvm[1]: linking debug shared library libllvm-3.0.so collect2: fatal error: ld terminated signal 9 [killed] compilation terminated. ... i went through answers online , might because there's not enough memory perform link. memory usage the gcc version on machine gcc version 5.4.0 20160609 (ubuntu 5.4.0-6ubuntu1~16.04.4) , installed via apt-get install build-essential . fresh droplet created on digitalocean btw. appreciated. it memory exhaustion. sampling interval memory measurement not small enough covers exact point oom killer kicks in. depending on container/vm technology, may able set vm.overcommit_memory=2 before build, process not killed (but doing requires m...
Read more