tm:读入数据框,保留文本ID,构造DTM并加入其他数据集

大猩猩

我正在使用软件包tm。

假设我有2列500行的数据框。第一列是随机生成的ID,其中包含字符和数字:“ txF87uyK”。第二列是实际文本:“今天的天气很好。约翰慢跑了。等等,等等...”

现在,我想根据此数据框创建一个文档术语矩阵。

我的问题是我想保留ID信息,以便在获得文档术语矩阵之后,可以将此矩阵与另一个矩阵合并,该矩阵的每一行都是每一文档的其他信息(日期,主题,情感),每一行是由文档ID标识。

我怎样才能做到这一点?

问题1:如何将该数据帧转换为语料并保留ID信息?

问题2:获取dtm后,如何将其与ID设置的另一个数据结合起来?

Ben

首先,来自https://stackoverflow.com/a/15506875/1036500的一些示例数据

examp1 <- "When discussing performance with colleagues, teaching, sending a bug report or searching for guidance on mailing lists and here on SO, a reproducible example is often asked and always helpful. What are your tips for creating an excellent example? How do you paste data structures from r in a text format? What other information should you include? Are there other tricks in addition to using dput(), dump() or structure()? When should you include library() or require() statements? Which reserved words should one avoid, in addition to c, df, data, etc? How does one make a great r reproducible example?"
examp2 <- "Sometimes the problem really isn't reproducible with a smaller piece of data, no matter how hard you try, and doesn't happen with synthetic data (although it's useful to show how you produced synthetic data sets that did not reproduce the problem, because it rules out some hypotheses). Posting the data to the web somewhere and providing a URL may be necessary. If the data can't be released to the public at large but could be shared at all, then you may be able to offer to e-mail it to interested parties (although this will cut down the number of people who will bother to work on it). I haven't actually seen this done, because people who can't release their data are sensitive about releasing it any form, but it would seem plausible that in some cases one could still post data if it were sufficiently anonymized/scrambled/corrupted slightly in some way. If you can't do either of these then you probably need to hire a consultant to solve your problem" 
examp3 <- "You are most likely to get good help with your R problem if you provide a reproducible example. A reproducible example allows someone else to recreate your problem by just copying and pasting R code. There are four things you need to include to make your example reproducible: required packages, data, code, and a description of your R environment. Packages should be loaded at the top of the script, so it's easy to see which ones the example needs. The easiest way to include data in an email is to use dput() to generate the R code to recreate it. For example, to recreate the mtcars dataset in R, I'd perform the following steps: Run dput(mtcars) in R Copy the output In my reproducible script, type mtcars <- then paste. Spend a little bit of time ensuring that your code is easy for others to read: make sure you've used spaces and your variable names are concise, but informative, use comments to indicate where your problem lies, do your best to remove everything that is not related to the problem. The shorter your code is, the easier it is to understand. Include the output of sessionInfo() as a comment. This summarises your R environment and makes it easy to check if you're using an out-of-date package. You can check you have actually made a reproducible example by starting up a fresh R session and pasting your script in. Before putting all of your code in an email, consider putting it on http://gist.github.com/. It will give your code nice syntax highlighting, and you don't have to worry about anything getting mangled by the email system."
examp4 <- "Do your homework before posting: If it is clear that you have done basic background research, you are far more likely to get an informative response. See also Further Resources further down this page. Do help.search(keyword) and apropos(keyword) with different keywords (type this at the R prompt). Do RSiteSearch(keyword) with different keywords (at the R prompt) to search R functions, contributed packages and R-Help postings. See ?RSiteSearch for further options and to restrict searches. Read the online help for relevant functions (type ?functionname, e.g., ?prod, at the R prompt) If something seems to have changed in R, look in the latest NEWS file on CRAN for information about it. Search the R-faq and the R-windows-faq if it might be relevant (http://cran.r-project.org/faqs.html) Read at least the relevant section in An Introduction to R If the function is from a package accompanying a book, e.g., the MASS package, consult the book before posting. The R Wiki has a section on finding functions and documentation"
examp5 <- "Before asking a technical question by e-mail, or in a newsgroup, or on a website chat board, do the following:  Try to find an answer by searching the archives of the forum you plan to post to. Try to find an answer by searching the Web. Try to find an answer by reading the manual. Try to find an answer by reading a FAQ. Try to find an answer by inspection or experimentation. Try to find an answer by asking a skilled friend. If you're a programmer, try to find an answer by reading the source code. When you ask your question, display the fact that you have done these things first; this will help establish that you're not being a lazy sponge and wasting people's time. Better yet, display what you have learned from doing these things. We like answering questions for people who have demonstrated they can learn from the answers. Use tactics like doing a Google search on the text of whatever error message you get (searching Google groups as well as Web pages). This might well take you straight to fix documentation or a mailing list thread answering your question. Even if it doesn't, saying “I googled on the following phrase but didn't get anything that looked promising” is a good thing to do in e-mail or news postings requesting help, if only because it records what searches won't help. It will also help to direct other people with similar problems to your thread by linking the search terms to what will hopefully be your problem and resolution thread. Take your time. Do not expect to be able to solve a complicated problem with a few seconds of Googling. Read and understand the FAQs, sit back, relax and give the problem some thought before approaching experts. Trust us, they will be able to tell from your questions how much reading and thinking you did, and will be more willing to help if you come prepared. Don't instantly fire your whole arsenal of questions just because your first search turned up no answers (or too many). Prepare your question. Think it through. Hasty-sounding questions get hasty answers, or none at all. The more you do to demonstrate that having put thought and effort into solving your problem before seeking help, the more likely you are to actually get help. Beware of asking the wrong question. If you ask one that is based on faulty assumptions, J. Random Hacker is quite likely to reply with a uselessly literal answer while thinking Stupid question..., and hoping the experience of getting what you asked for rather than what you needed will teach you a lesson."

将示例数据放在数据框中...

df <- data.frame(ID = sapply(1:5, function(i) paste0(sample(letters, 5), collapse = "")),
                 txt = sapply(1:5, function(i) eval(parse(text=paste0("examp",i))))
                 )

这是对“问题1:如何将此数据帧转换为语料并保留ID信息?”的答案。

使用DataframeSourcereaderControl将数据帧转换为语料库(来自https://stackoverflow.com/a/15693766/1036500)...

require(tm)
m <- list(ID = "ID", Content = "txt")
myReader <- readTabular(mapping = m)
mycorpus <- Corpus(DataframeSource(df), readerControl = list(reader = myReader))

# Manually keep ID information from https://stackoverflow.com/a/14852502/1036500
for (i in 1:length(mycorpus)) {
  attr(mycorpus[[i]], "ID") <- df$ID[i]
}

现在为您的第二个问题提供一些示例数据...

https://stackoverflow.com/a/15506875/1036500制作文档术语矩阵...

skipWords <- function(x) removeWords(x, stopwords("english"))
funcs <- list(content_transformer(tolower), removePunctuation, removeNumbers, stripWhitespace, skipWords)
a <- tm_map(mycorpus, FUN = tm_reduce, tmFuns = funcs)
mydtm <- DocumentTermMatrix(a, control = list(wordLengths = c(3,10)))
inspect(mydtm)

制作另一个示例数据集以加入...

df2 <- data.frame(ID = df$ID,
                  date =  seq(Sys.Date(), length.out=5, by="1 week"),
                  topic =   sapply(1:5, function(i) paste0(sample(LETTERS, 3), collapse = "")) ,
                  sentiment = sample(c("+ve", "-ve"), 5, replace = TRUE)
                  )

这是对“问题2:获得dtm之后,如何将其与ID设置的另一个数据结合在一起?”的答案。

用于merge将dtm加入日期,主题,情感等示例数据集...

mydtm_df <- data.frame(as.matrix(mydtm))
# merge by row.names from https://stackoverflow.com/a/7739757/1036500
merged <- merge(df2, mydtm_df, by.x = "ID", by.y = "row.names" )
head(merged)

      ID     date.x topic sentiment able actually addition allows also although
1 cpjmn 2013-11-07   XRT       -ve    0        0        2      0    0        0
2 jkdaf 2013-11-28   TYJ       -ve    0        0        0      0    1        0
3 jstpa 2013-12-05   SVB       -ve    2        1        0      0    1        0
4 sfywr 2013-11-14   OMG       -ve    1        1        0      0    0        2
5 ylaqr 2013-11-21   KDY       +ve    0        1        0      1    0        0
always answer answering answers anything archives are arsenal ask asked asking
1      1      0         0       0        0        0   1       0   0     1      0
2      0      0         0       0        0        0   0       0   0     0      0
3      0      8         2       3        1        1   0       1   2     1      3
4      0      0         0       0        0        0   0       0   0     0      0
5      0      0         0       0        1        0   0       0   0     0      0

在那里,现在您有了:

  1. 回答您的两个问题(通常,此网站每个问题仅一个问题)
  2. 提出下一个问题时可以使用几种示例数据(使您的问题对可能想要回答的人们更具吸引力)
  3. 如果您可以考虑如何将问题分解为更小的步骤,希望可以在stackoverflow 标签的其他位置找到问题的答案

如果这不能回答您的问题,请提出另一个问题,并包含代码以尽可能精确地重现您的用例。如果它确实回答了您的问题,则应将其标记为已接受(至少在出现更好的问题之前,例如,Tyler可能会从其令人印象深刻的qdap软件包中弹出一条衬里...)

本文收集自互联网,转载请注明来源。

如有侵权,请联系[email protected] 删除。

编辑于
0

我来说两句

0条评论
登录后参与评论

相关文章

来自分类Dev

tm:读入数据框,保留文本ID,构造DTM并加入其他数据集

来自分类Dev

大熊猫加入两个数据框,如果其他数据框中不存在某些行,则保留来自一个数据集的数据

来自分类Dev

将文本读入数据框

来自分类Dev

如何分组重复值但保留数据框的其他列

来自分类Dev

数据框加入多个ID

来自分类Dev

从其他数据框填写数据框

来自分类Dev

将数据从文本格式读入Python Pandas数据框

来自分类Dev

从其他数据框映射

来自分类Dev

如何用其他数据框中的ID替换数据框中的2列值?

来自分类常见问题

熊猫将文本文件读入数据框

来自分类Dev

熊猫将文本文件读入数据框

来自分类Dev

从其他包含文本格式数据的列中创建熊猫数据框的列

来自分类Dev

从其他列中取消列出数据框列保留信息

来自分类Dev

Pandas:仅将数据框中的数字转换为数字,保留其他所有内容

来自分类Dev

根据R中其他列的功能构造数据框列

来自分类Dev

使用Groupby构造一个具有其他列的值计数的数据框

来自分类Dev

RDF与其他数据集的互连

来自分类Dev

RDF与其他数据集的互连

来自分类Dev

熊猫数据框,按最后一列的最后位置拆分数据,但保留其他列

来自分类Dev

在 Pandas 数据框中插入新行,在保留其他数据的同时更改一些时间戳

来自分类Dev

熊猫来自其他数据框的多个数据框

来自分类Dev

根据其他数据框从数据框中选择值

来自分类Dev

使用其他数据框的某些列创建数据框

来自分类Dev

根据其他数据框的列映射数据框

来自分类Dev

根据其他数据框过滤熊猫数据框列

来自分类Dev

在不同的数据框中保留相同的ID

来自分类Dev

压缩并加入数据框

来自分类Dev

从其他数据框替换值

来自分类Dev

如何在文本框值中输入当前日期并显示我的其他数据

Related 相关文章

  1. 1

    tm:读入数据框,保留文本ID,构造DTM并加入其他数据集

  2. 2

    大熊猫加入两个数据框,如果其他数据框中不存在某些行,则保留来自一个数据集的数据

  3. 3

    将文本读入数据框

  4. 4

    如何分组重复值但保留数据框的其他列

  5. 5

    数据框加入多个ID

  6. 6

    从其他数据框填写数据框

  7. 7

    将数据从文本格式读入Python Pandas数据框

  8. 8

    从其他数据框映射

  9. 9

    如何用其他数据框中的ID替换数据框中的2列值?

  10. 10

    熊猫将文本文件读入数据框

  11. 11

    熊猫将文本文件读入数据框

  12. 12

    从其他包含文本格式数据的列中创建熊猫数据框的列

  13. 13

    从其他列中取消列出数据框列保留信息

  14. 14

    Pandas:仅将数据框中的数字转换为数字,保留其他所有内容

  15. 15

    根据R中其他列的功能构造数据框列

  16. 16

    使用Groupby构造一个具有其他列的值计数的数据框

  17. 17

    RDF与其他数据集的互连

  18. 18

    RDF与其他数据集的互连

  19. 19

    熊猫数据框,按最后一列的最后位置拆分数据,但保留其他列

  20. 20

    在 Pandas 数据框中插入新行,在保留其他数据的同时更改一些时间戳

  21. 21

    熊猫来自其他数据框的多个数据框

  22. 22

    根据其他数据框从数据框中选择值

  23. 23

    使用其他数据框的某些列创建数据框

  24. 24

    根据其他数据框的列映射数据框

  25. 25

    根据其他数据框过滤熊猫数据框列

  26. 26

    在不同的数据框中保留相同的ID

  27. 27

    压缩并加入数据框

  28. 28

    从其他数据框替换值

  29. 29

    如何在文本框值中输入当前日期并显示我的其他数据

热门标签

归档