Displaying 20 results from an estimated 300 matches similar to: "data frame manipulation"
2010 Apr 29
3
convert Factor as numeric
Dear group,
I know this issue has been already covered, and before you reply I must say
I have read the R-FAQ and search the mailing list archive.
I still can't manage to change my factor to numeric as I couldn't find any
clear answer.
Here is my df :
Pose1 <-
structure(list(DESCRIPTION = structure(c(1L, 2L, 3L, 4L, 5L,
8L), .Label = c(" SUGAR NO.11 May/10 ", "COTTON
2010 Apr 15
1
sum rows in a data.frame...solution
Found this solution. It is maybe not the most elegant way, but it does the
job.
> a=as.data.frame(substr(lme$DESCRIPTION,1,14))
> colnames(a)=c("DESCRIPTION")
> lme=as.data.frame(c(a,lme[,2:3]))
> lme
DESCRIPTION CLOSING.PRICE POSITION
1 PRIMARY NICKEL 25,755.7100 0
2 PRIMARY NICKEL 25,760.8600 0
3 PRM HGH GD ALU 2,415.9000 0
2010 Apr 30
1
read.csv and blank character in object name of my data.frame
Dear group,
Here is my data frame:
position100415 <-
structure(list(DESCRIPTION = structure(1:9, .Label = c(" SUGAR NO.11 Jul/10
",
" SUGAR NO.11 May/10 ", "CORN May/10 ", "COTTON NO.2 Jul/10 ",
"CRUDE OIL miNY May/10 ", "ROBUSTA COFFEE (10) Jul/10 ", "SILVER May/10 ",
"SOYBEANS Jul/10 ", "WHEAT May/10
2010 Apr 15
4
Does "sink" stand for anything?
Hello Everyone,
Learning about R and its wonderful array of functions. If it's not obvious, I usually try to find out what a function stands for. I think this helps me remember better.
One function that has me stumped is "sink." Can anyone tell me if this stands for something?
Thanks,
Paul
__________________________________________________
[[alternative HTML
2010 Apr 23
3
substract start from the end of the vector
Dear group,
Here is my df :
df <-
structure(list(DESCRIPTION = c("PRM HGH GD ALUMINIUM USD 09/07/10 ",
"PRM HGH GD ALUMINIUM USD 09/07/10 ", "PRIMARY NICKEL USD 04/06/10 "
), CREATED.DATE = structure(c(18361, 18361, 18325), class = "Date"),
QUANITY = c(-1L, 1L, 1L), CLOSING.PRICE = c("2,415.90", "2,415.90",
2010 May 11
1
merge two data frames
Dear group,
I have these 2 following data frame:
allcon <-
structure(list(DESCRIPTION = structure(1:17, .Label = c("COFFEE C Jul/10",
"COPPER May/10", "CORN Jul/10", "CORN May/10", "COTTON NO.2 Jul/10",
"CRUDE OIL miNY May/10", "GOLD Jun/10", "HENRY HUB NATURAL GAS May/10",
"ROBUSTA COFFEE (10)
2010 Aug 04
3
merge two data frames
Dear list,
here are my two data frames:
av <-
structure(list(DESCRIPTION = c("COFFEE C Sep/10", "COPPER Sep/10",
"CORN Dec/10", "CRUDE OIL miNY Sep/10", "GOLD Aug/10", "HENRY HUB
NATURAL GAS Sep/10",
"PALLADIUM Sep/10", "SILVER Sep/10", "SOYBEANS Nov/10", "SPCL HIGH
GRADE ZINC USD",
"SUGAR
2010 May 11
1
merging data frame
Dear group,
I have 3 data frames I would like to merge.
Here they are:
pose16 <-
structure(list(DESCRIPTION = structure(c(1L, 2L, 3L, 4L, 5L,
6L, 7L, 8L, 9L, 12L), .Label = c("COPPER May/10", "COTTON NO.2 Jul/10",
"CRUDE OIL miNY May/10", "GOLD Jun/10", "ROBUSTA COFFEE (10) Jul/10",
"SOYBEANS Jul/10", "SUGAR NO.11
2010 May 12
1
data frame subscription
Dear group,
Here is my df :
pose16 <-
structure(list(DESCRIPTION = structure(c(1L, 2L, 3L, 4L, 5L,
6L, 7L, 8L, 9L, 12L), .Label = c("COPPER May/10", "COTTON NO.2 Jul/10",
"CRUDE OIL miNY May/10", "GOLD Jun/10", "ROBUSTA COFFEE (10) Jul/10",
"SOYBEANS Jul/10", "SUGAR NO.11 Jul/10", "SUGAR NO.11 May/10",
2010 Apr 28
1
gsub,regex and replacing
Dear group,
I need to modify some characters in a data frame. I want to use gsub and the
regex functionalities to do this.
Here is the data frame (df):
DESCRIPTION prix quantity
1 CORN Jul/10 -1.5 0
2 CORN May/10 -1082.0 -3
3 ROBUSTA COFFEE (10) Jul/10 11084.0 8
4 SOYBEANS Jul/10 1983.5
2010 Apr 23
2
read.csv data frame thousands separator
Dear group,
Here is my df, trades1 :
trades1 <-
structure(list(Instrument.Long.Name = c("CORN", "CORN", "CORN",
"CORN", "CORN", "SOYBEANS", "SOYBEANS", "SOYBEANS", "SOYBEANS",
"SOYBEANS", "SOYBEANS", "STANDARD LEAD USD", "STANDARD LEAD USD",
"SPCL
2010 Jun 01
3
as.date
Dear group,
Here is my df (obtained with a read.csv2()):
df <-
structure(list(DESCRIPTION = c("COTTON NO.2 Jul/10", "COTTON NO.2 Jul/10",
"PALLADIUM Jun/10", "PALLADIUM Jun/10", "SUGAR NO.11 Jul/10",
"SUGAR NO.11 Jul/10"), CREATED.DATE = c("13/05/2010", "13/05/2010",
"14/05/2010",
2010 Apr 28
3
data frame move columns
Dear group,
Here is my df:
avprix <-
structure(list(DESCRIPTION = c("CORN Jul/10", "CORN May/10",
"ROBUSTA COFFEE (10) Jul/10", "SOYBEANS Jul/10", "SPCL HIGH GRADE ZINC USD",
"STANDARD LEAD USD"), prix = c(-1.5, -1082, 11084, 1983.5, -2464,
-118), quantity = c(0, -3, 8, 2, -1, 0), fees = c(-8.64, -30.24,
-26.4, -25.92, -37.5,
2010 May 11
2
Regex and gsub
Dear group,
Here is my df :
df3 <-
structure(list(DESCRIPTION = c("COPPER May/10", "COTTON NO.2 Jul/10",
"CRUDE OIL miNY May/10", "GOLD Jun/10", "ROBUSTA COFFEE (10) Jul/10",
"SOYBEANS Jul/10", "SUGAR NO.11 Jul/10", "SUGAR NO.11 May/10",
"WHEAT Jul/10", "SPCL HIGH GRADE ZINC USD",
2010 May 26
5
(no subject)
Dear group,
Here is my data frame:
> dput(u)
structure(list(DESCRIPTION = structure(c(2L, 5L, 6L, 7L, 9L,
11L, 12L, 15L, 14L, 16L, 1L, 10L, 3L, 4L, 13L, 8L, 17L), .Label = c("COFFEE
C Jul/10",
"COPPER May/10", "CORN Jul/10", "CORN May/10", "COTTON NO.2 Jul/10",
"CRUDE OIL miNY May/10", "GOLD Jun/10", "HENRY HUB
2010 Apr 14
6
sum specific rows in a data frame
I have a data frame called "pose":
DESCRIPTION QUANITY CLOSING.PRICE
1 WHEAT May/10 1 467.75
2 WHEAT May/10 2 467.75
3 WHEAT May/10 1 467.75
4 WHEAT May/10 1 467.75
5 COTTON NO.2 May/10 1 78.13
6 COTTON NO.2 May/10 3 78.13
7 COTTON NO.2 May/10 1 78.13
2010 Apr 27
1
save a data frame in environment
Dear group,
Here is my function :
position<-function(x)
{
pose<-read.csv2((paste(c("LSCPos",x,".csv"),collapse="")),dec=".",sep=",",as
.is=T,h=T,skip=1)[,c(4,8,14,15)]
pose$CREATED.DATE<-as.Date(pose$CREATED.DATE,"%d/%m/%y")
futures<-pose[-grep("USD",pose[,1]),]
2015 Oct 17
3
Help with voicemail
Hi list!
My problem: I have three extensions in my Asterisk 1.8.30.0 and they have a
voicemail.
On two of these numbers the voicemail works without any problem, on the other
it doesn't...
I get this error:
[Oct 17 17:01:29] WARNING[14700]: channel.c:5254 set_format: Unable to find a codec translation path from 0x100 (g729) to 0x2 (gsm)
[Oct 17 17:01:29] WARNING[14700]: file.c:957
2004 Aug 06
0
Medical Breakthrough... aging can be reversed with HGH
There are three different types of HGH products.
The confusion is that all three are
advertised as if they were the same.
The three types are:
1) --- Homeopathic HGH
2) --- Pre-cursor HGH
3) --- Real or synthetic HGH (delivered by injection
or, by an oral spray method).
Do you know differences?
Call us and we'll explain them to you.
Our toll free number is
2004 Aug 06
0
Medical Breakthrough... aging can be reversed with HGH
There are three different types of HGH products.
The confusion is that all three are
advertised as if they were the same.
The three types are:
1) --- Homeopathic HGH
2) --- Pre-cursor HGH
3) --- Real or synthetic HGH (delivered by injection
or, by an oral spray method).
Do you know differences?
Call us and we'll explain them to you.
Our toll free number is