Displaying 20 results from an estimated 3000 matches similar to: "Sum of specific column"
2007 Jun 20
3
Replace number with month
Hi all
I have a multiple datasets that look like this
MM Freq
1 30
2 35
3 54
4 33
5 27
6 13
7 25
8 29
9 40
10 32
11 36
12 23
I am plotting this using barchart (there is probably something better
but it gives me the results I want) and I would like the x-axis to have
the names of the months instead of the month numbers. So I have
2007 Jun 22
1
Barchart legend position
I am using barchart to make charts for some data with a lot more
functions and labels and such in the command.
barchart(Freq ~ factor(HH), data = dataset1, group= year)
So I have my data grouped by year and I get a legend at the top of
graph, which is great cause I need the legend for the different years
but it is a weird spot. So how can I manipulate the legend, ie. Move
it, shrink it, do
2008 Jan 23
1
Bar width and labels in barchart
Hi everyone
I am using barchart to make my graphs. Here is my code.
barchart(percent_below ~ factor(Year)| factor(Season,
levels=unique(Season)),
data= .season_occurrence, origin = 0, layout = c(4, 1),
scales=list(tick.number=ticknum,labels=NULL), ylim=c(0, ymax),
group = factor(Year), xlab= "Year", auto.key = list(points =
FALSE, rectangles =
2008 Nov 24
4
Replace NaN with zero
I need help with replacing NaN with zero (the value '0') in my dataset.
The reason is that I can't get it to graph because of the NaN in the
dataset. I have tried:
data[is.nan(data)] <- 0
that others have suggested in the help archives but this does nothing so
I am not sure what I am doing wrong.
Thanks in advance for your help.
[[alternative HTML version deleted]]
2007 May 10
1
Barplot by two variables
Hi all
I have a bit of a problem. I want to make a barplot of some data. My
data is of a score that is separated by year and by a limit (above 3 and
below 3 to calculate the score).
Year Limit HSS
1999 ALT 0.675
1999 VFR 0.521
2000 ALT 0.264
2000 VFR 0.295
I would like to have a barplot with year on the x axis and HSS on the y
axis and the two limits as two different colors to show the
2007 May 15
1
How to group a count
Hello R users
I have a dataset that has different types of records with different
dates and times pertaining to each. I would like to have a bar graph of
a count of the types(ie. The number of types) of recods by hour grouped
by year. So the count of the types would be the y axis, the hour on the
x axis and then grouped by year for easy comparison. I think that I
have to use barchart however I
2007 Dec 19
1
adding lines to a barchart
Hi all
I can't find what I am looking for so I am asking here. I have a
dataset that looks something like this.
Year season percent_below
2000 Winter 6.9179870
2000 Spring 1.6829436
2000 Summer 1.8463501
2000 Autumn 3.8184993
2001 Winter 2.8832806
2001 Spring 2.5870511
2001 Summer 0.0000000
2001 Autumn 4.7248240
2002 Winter
2007 Sep 19
1
Subset any value and blanks
Hi everyone
I need help with subseting a data set. In my dataset there is a
specific row that will either have a value or be blank. I would like to
subset (or split) the dataset into one dataset with the row that has the
value and another dataset that has just the blanks. Now the thing is
that the row that has the value in it, the value is not always the same,
it is a time stamp of when
2007 Jun 29
1
Assign name to a name
I would like to know how I can assign a name to a name. I have a
dataset that has different years in it. I am writing scripts using R
and I would like to give a month a generic name and then use the generic
name to do different analysis. The reason for the generic name would be
so that I only have to change one thing if I wanted to change the year.
For example.
Year1 = 1999
datayear <-
2005 May 02
4
"apply" question
Dear R users,
I??ve got a simple question but somehow I can??t find the solution:
I have a data frame with columns 1-5 containing one set of integer
values, and columns 6-10 containing another set of integer values.
Columns 6-10 contain NA??s at some places.
I now want to calculate
(1) the number of values in each row of columns 6-10 that were NA??s
(2) the sum of all values on columns 1-5
2008 Mar 16
2
How to loop through all the columns in dataframe
Hi:
Can anyone advice me on how to loop and perform a
calculation through all the columns.
here's my data
xd<-
c(2.2024,2.4216,1.4672,1.4817,1.4957,1.4431,1.5676)
pd<-
c(0.017046,0.018504,0.012157,0.012253,0.012348,0.011997,0.012825)
td<- c(160524,163565,143973,111956,89677,95269,81558)
mydf<-data.frame(xd,pd,td)
trans<-t(mydf)
trans
I have these values that I need to
2010 Mar 22
1
help needed with boxplot
I am new to R, can anyone help with boxplot for a dataset like:
file1 col1 col2 col3 col4 col5
050350005 101 56.625 48.318 RED
051010002 106 50.625 46.990 GREEN
051190007 25 65.875 74.545 BLUE
051191002 246 52.875 57.070 RED
220050004 55 70 80.274 BLUE
220150008 75 67.750 62.749 RED
220170001 77 65.750 54.307 GREEN
file2
col1 col2 col3 col4 col5
050350005 101 56.625 57 RED
051010002 106 50.625 77
2007 Apr 11
2
Looping through series of names
Hi
I am very new to R and have not able to find the answer to my question
in the manual or any other post. I have a dataset that has various
different sites names with data relating to each site. The data is in
one dataset. I want to loop through the different site names and
perform my test on each site. The sites are named not numbers for
example "YYC". How do I do this. I hope I
2006 Dec 14
5
Better way to change the name of a column in a dataframe?
Hello R users --
If I have a dataframe such as the following, named "frame" with the
columns intended to be named col1 through col6,
> frame
col1 col2 cmlo3 col4 col5 col6
[1,] 3 10 2 6 5 7
[2,] 6 8 4 10 7 1
[3,] 7 5 1 3 1 8
[4,] 10 6 5 4 9 2
and I want to correct or otherwise change the
2008 Apr 09
1
Replace values according to conditions
Greetings R-users,
I have the following data called mydata in a data.frame
Col1 Col2 Col3 Col4 Col5
1 2 4 6 7
8 8 7 3 5
4 4 5 6 7
I want to replace the data according to the following conditions
Condition 1 if data <= 3, replace with -1
Condition 2 if data >=6, replace with 1
Condition 3 if data = 4 or data =5, replace with 0
2010 Oct 21
2
Adding rows to column
I'm new to R.
I'm extracting important columns from single table using following code:
File2<-"file.txt"
table2<- read.delim(File2, skip=19, sep=";", header=F, na.strings=NA,
fill=T)
#extracting column 7 where rows match "ID"
col1<- table2[grep("ID", table2[,1]),7]
#similarly extracting column 9,11,13,15
col2<-
2012 Oct 18
4
speeding read.table
R 2.15.1
OS X
Colleagues,
I am reading a 1 GB file into R using read.table. The file consists of 100 tables, each of which is headed by two lines of characters.
The first of these lines is:
TABLE NO. 1
The second is a list of column headers.
For example:
TABLE NO. 1
COL1 COL2 COL3 COL4 COL5 COL6 COL7 COL8 COL9 COL10
2011 Jan 24
2
how to slice a zoo object
Hi
Would anyone have any pointers on how to slice up a large zoo table. I
have the following structure: -
> str(ZOO_OBJ)
?zoo [1:632, 1:83] 30.4 30.4 30.4 30.4 30.3 ...
?- attr(*, "dimnames")=List of 2
??..$ : NULL
??..$ : chr [1:83] "COL1" "COL2" "COL3" "COL4" ...
?- attr(*, "index")= POSIXct[1:632], format: "2009-05-01
2011 Aug 25
2
replicate lines of data frame
Greetings!
I am just now learning to use R for my dissertation project. I need
to manipulate a lot of text and numeric data. I created a data frame
that has 7 columns and 127 unique rows. Now I need to replicate each
line 6 times and then later change values in the first 2 columns.
I am trying to figure out how to accomplish this. I think that I need
to use rep(my.df, each=6) but it does
2016 Dec 20
2
colnames for data.frame could be greatly improved
Hello,
colnames seems to be not optimized well for data.frame. It escapes
processing for data.frame in
if (is.data.frame(x) && do.NULL)
return(names(x))
but only when do.NULL true. This makes huge difference when do.NULL
false. Minimal edit to `colnames`:
if (is.data.frame(x)) {
nm <- names(x)
if (do.NULL || !is.null(nm))
return(nm)
else