similar to: how to combine unequal rows and columns in R

Displaying 20 results from an estimated 600 matches similar to: "how to combine unequal rows and columns in R"

2013 Mar 14
3
how to change "`Year_Month)201103`" into "Year_Month)201103" using R?
HI, I have the pattern like "`Year_Month)201103`" I want to delete single quotes within double quetes. I want to change it into "Year_Month)201103" , how to do it in r? Thanks a lot. Tammy [[alternative HTML version deleted]]
2013 Mar 15
3
How to list the all products' information of the latest month?
Hi, I have data frame like this: Product Price Year_Month PE A 100 201012 -2 A 98 201101 -3 A 97 201102 -2.5 B 110 201101 -1 B 100 201102 -2 B 90 201103 -4 How can I achieve the following result
2012 Jun 01
2
Day or Month difference between dates???
HI, R-Users: I got a questions. have been struggling so long time.... I have this data: > m1$Year_Month 201009 201010 201011 201101 201102 > min(m1$Year_Month) 201009 I want to calculate the following two answers, how do I program it? > difference in Month????? [1] 0 1 2 4 5 >difference in Days????? 0 31 61 .... Thank you in advance!!! Tammy [[alternative
2012 Nov 18
3
Replace <NA> with something else
I am reading some data into R from an Excel spreadsheet using read.csv. Some of the original data that comes into column 1 from the spreadsheet is text that says NA. The NA stands for north america. As it comes in, R converts the NA over to <NA>. What is the cleanest way to change the <NA> values to something else. In other words, get rid of the brackets ? Maybe convert <NA>
2013 Mar 26
1
Shifting cells and removing blanks
Hi , I've been struggling with this problem. Initially I thought something like a na.locf would help but I'm at a dead end. I have a data set like this: ID Prod1 Prod2 Prod3 Prod4 Prod5 01 A - B - C 02 - F - G - 03 H - - - J And I would like to remove all
2012 Dec 13
3
how to aggregate the dataset
HI, Sorry for messing up.. I want to transform the following dataset: product min_price max_price mean_price country price_band 11 34 50 40 VN 0-300 22 10 30 15 VN 0-300 Into: product VN price_band 11 40 0-300 [34,50] 22 15
2012 Nov 08
5
map two names into one
Thanks. Yes. Your approach can identify: Glaxy ace S 5830 and S 5830 Glaxy ace But you can not identify using same program: Iphone 4S 16 G Iphone 4S 16G How should I solve both in same time. Kind regards,Tammy [[alternative HTML version deleted]]
2020 Jul 27
3
Migration from one server to 2 new servers
Fair enough but the command snippet I posted was taken directly from your earlier post dated Mon Jul 27 23:11:06 EEST 2020 and it does say ?production1??I just double-checked as well... FWIW?the server order in the command you just pasted is the exact reverse from the Jul 27th post I mentioned above? Here you appear to be exec?ing the command on prod2 and trying to pull from the remote of prod
2009 Oct 01
2
The problem of readLines
Dear R-users, I use "readLines" to read data, but when processing the large data set, there are few files which can not be readed in: 48: In readLines(name_c[i]) ... : incomplete final line found on 'C:/Documents and Settings/lma/My Documents/habitdata/244052900243997/calllog/calllog_log-20050505T121611.txt' ... Whats the problem about this? Regards, Tammy
2013 Jan 25
3
how to delete the null elements in list
HI, I have the list: > suu [[1]] NULL [[2]] NULL [[3]] item_id prod 1 2 [[4]] item_id prod 1 2 2 4 how to delete all "NULL" elements from suu to get only >suu [[3]] item_id prod 1 2 [[4]] item_id prod 1 2 2 4 ?? Kind regards, Tammy [[alternative HTML version deleted]]
2013 Jan 22
3
How to align group based on the common values of two columns in r
HI, I met this problem: I have the feature data frame: Feature OS 4 2 4 1 4 3 1 2 4 1 what I want to do is to autimatically create one more column called "group": Feature OS Group 4 2 1 4 1 2 4 3
2009 Sep 01
3
data frame
HI, R user, I generate the vectors with the same length. I want to put each vector into each column of data frame. Why it doesnt work`? rm<-data.frame() for(a in 1:6){ rm[,a]<-getmeasure(p1,a,speech) } thanks a lot Tammy _________________________________________________________________ Share your memories online with anyone you want.
2009 Mar 17
4
Merging
Hi, All. I have a data frame with the part as : ..... 142 2006-02-22 16:28:18 useractivity_act 8 0 143 2006-02-22 16:28:26 4 2 0 144 2006-02-22 16:28:28 3 3 0 145 2006-02-22 16:28:31 4 4 1 146 2006-02-22 16:28:35 3 159 0 147
2012 Dec 12
2
how to grep in r
Hi, I met this problem. Trade_Price_Band x 1 0-30 0.6237240 2 101-150 0.6743857 3 151-200 0.6778513 4 201-300 0.6640293 5 301-400 0.6630991 6 31-50 0.6314547 7 401-500 0.6776249 8 500+ 0.6557705 9 51-75 0.6621073 10 76-100 0.6623469 I want to get the following matrix
2013 Mar 14
2
HOw to achieve big vector times big dataframe in R?
HI, I have the following question: Vector a with lenght 150 A B C D......... dataframe b with dim 908X150 1 1 1 1..... 2 2 2 2 3 3 3 3 4 4 4 4 ................ final result I want is the vector with length 908: A*1+B*1+C*1+D*1+..... A*2+B*2+C*2+D*2+..... A*3+B*3+C*3+D*3+..... A*4+B*4+C*4+D*4+..... .... because of too large dimension, how can I achieve this in R?
2012 Sep 26
3
map two names into one
Dear R user: I have got the following problem: I have imported two data sets into R: one set includes price information, another one includes volume information. but I noticed the wrong data order problem in the product name, for instance, in one data set, "GALAXY ACE S 5830" in another one, it is "S 5830 GALAXY ACE" both represent same product. how do i map two name
2012 Dec 13
2
How to create multiple country's data into multiple sheets of one excel
HI, I have large dataset of many countries. I have written the program to run through each country to generate one output for each country. I want to put the output like this: one sheet has output for one country. How do I achieve it by r. I have tried this: library(xlsx) write.xlsx(nnn, "vn.xlsx", sheetName="Sheet1") [1] but when I change sheetName="Sheet2"
2013 Jan 25
2
How to name the elements of list
HI, I have the array list: X<-vector("list", 2) X[[1]] : data frame 1 X[[2]]: dataframe2 now i want to change index 1 and 2 into: "0-10" , "11-20" ,. finally I want to have X[["0-10"]]:dataframe1 X[["11-20"]]:dataframe2 how do I get them? Thanks a lot. Kind regards, Tammy [[alternative HTML version deleted]]
2012 Dec 05
2
how to assign factor level into each value
HI, All I met the following problem. I dont know how to handle it. Country Price 1 CN 44.25 2 CN 21.07 3 CN 92.70 4 CN 47.41 5 CN 111.67 6 CN 50.57 I want to create the 3rd colume with different
2006 Sep 07
2
Running two clusters side by side
I''m happy to announce that ChaCha.com a new search engine that debuted this week and it runs on a mongrel cluster. Warning, promo follows. :) ChaCha.com is unlike any other search engine since it allows you to connect to a "guide" with experience in the field(s) of knowledge you are searching in. (Based on your keywords) Check it out at http://www.chacha.com Now on to my