similar to: reading data from Excel Spread sheet

Displaying 20 results from an estimated 4000 matches similar to: "reading data from Excel Spread sheet"

2010 Jun 22
3
Problem with writing a CSV file in UTF-8 formate
Hi all, I have a problem with writing a *.CSV file in UTF-8 formate I tried to write a dataframe named "dfPREINDX" to the new file named "preindx.csv" in below formate write.table(dfPREINDX,PreIndex,fileEncoding="UTF-8",sep="|",row.names=FALSE) but its throed an error like Error in write.table(dfPREINDX, "preindx.csv", fileEncoding =
2009 Feb 02
2
parsing problem
Hi all, I am trying to parse a vector for caliculating minimum in that vector the vector having values like 1 Kontrolle 2 Placebo 3 125mg/kg 4 250mg/kg 5 500mg/kg 6 1000mg/kg hear i tries for comverting it into numeric with using "as.numaric()" function but i got values like 5 6 2 3 4 1 it gives 1000mg/kg is the least one but i have
2009 Dec 17
2
Problem with spliting a dataframe values
Hi all, Hi this is kiran I am facing a problem to split a dataframe that is.. i have a string like: "a,b,c|1,2,3|4,5,6|7,8,8" first I have to split with respect to "|" I did it with command unlist(strsplit("a,b,c|1,2,3|4,5,6|7,8,8", "\\,")) after getting that set i made it as a dataframe and it comes like a,b,c 1,2,3 4,5,6 7,8,8 now i have to
2009 Jun 08
2
problem with bulk insert into a *.csv file
Hi all, I am trying to create a "index.csv" with caliculating different types of caliculations . In that i have to caliculate on 10,000 studies and have to insert many no of rows more than 500,000 for that right now I am inserting every row after caliculating and doing data.frame but its taking much time to create that index.csv is there any thing like bulk insert in to file
2010 Mar 09
2
Problem with mean
Hi all, I got one intresting problem with caliculating mean that is while i am taking mean of values *0.6, -0.8, 4, -3.8* using *val<-c(0.6, -0.8, 4, -3.8)* *mean(val)* it given result as *2.775558e-17* but the actual result is *"0"* can any one suggest how can I get correct mean result in this case can any one suggest how I can farward thanks in regards kiran [[alternative
2010 Apr 20
2
problem with retreaving column from a data.frame
Hi all, I have a problem with retreaving column from a data.frame that is I have a data.frame named "temp" in that dataframe some column are there whose names are "IDENTIFIER" "UNIQUEID" "TRIALGROUPSID" "GRPNUMBER" "GRPDESC" "SEXDID" "STDID" "STUDYTYPE" "SDID"
2009 Nov 11
2
creating custom package and functions
Hi all, I am new to R-project I have to create custom package and some required functions in that package can any one help me how to create a custompackage and how to write my function in to that package These things I have to use in many places as per requirements in my solution please help me to create these custom packages thanks in advance kiran. [[alternative HTML version deleted]]
2009 Nov 10
1
problem with executing r-function from windows command prompt
Hi all, I am trying to execute one function from windows command prompt and I am trying to execute queries like source(myRfile.R) but itis throughing runtime errors can any one help me how can i run my *.R file and how can i call a function in that *.R file thanks in advance kiran. [[alternative HTML version deleted]]
2010 Feb 01
1
problem withrbind function
Hi all, I am trying to to merge two data.frames(kk and ff) like > kk a b d 1 1 4 7 2 2 5 8 3 3 6 9 > ff a b d 1 2 5 8 2 3 6 9 3 4 7 1 and g<-rbind(kk,ff) is working perfectly and giving results but if any of the column name changed then its giving "Error in match.names(clabs, names(xi)) : names do not match previous names" like > kk a b d 1 1 4 7 2 2 5 8 3 3
2010 May 26
1
problem with not in in subseting dataframe
Hi all, I have a problem while subsetting a dataframe that is while I am using *%in%* condition like *stemp<-subset(temp, obj1 %in% obj2,select=c(temp))* this is working and giving results that what ever is there is both *obj1*and *obj2* ** ** but I want to get values which is there in *obj1* but not in *obj2 * can anyone help me how to get those values. i tried with *%o%* but i am not
2009 Mar 10
2
problem with concatinating string while taking as a path of a file
Hi all, I have a problem with concatinating strings while taking as a path here the problem is i have to take path as FPATH<-"D:\\Kiran" and file name as Fname<-"FINDINGS.CSV" and while I am reading this table I have to take path with using these two strings because in "FPATH" there is many files like findings.csv, and path will be
2009 Jan 28
2
Grouping problem
Hi all, I have a problem with grouping like I have to give count of employes in each department like if in one company there is departments like Mechanical, Computer, Fitting, electronics and Chemical hear I have to retreave the number of employes in each department and as well as I have to retreave number of John's in each department is there any function is there which can solve my
2009 Jun 22
2
problem with checking wether file is present or not
Hi all, I have a problem with checking File is present in the directory or not like I have a sequence of files in one folder I have to take each file in order and have to caliculate on those files data but in order some files are missing for that I have to check and load those files for that I am using condition like if(file.exists(findings)==TRUE){} its giving results for files which are
2009 Jan 20
1
problem with applying where condition
Hi all, I am a biggener in R-Project I got one problem with applying *where condition* like if 2 tables like table1: empid name dep 101 kiran solutions 102 ram testing 103 pavan database table2: empid month sal 101 Dec 9500 102 Dec 9800 103 Dec 8500 in first table i have to take *empid* with
2009 Feb 09
2
Problem in appending a row to *.csv file
Hi all, I am new to R-project I have a problem when when ever I am going to append a row in a *.csv file that is in R-project I created one dataframe and I saved it in "res.csv" and again I got some results in dataframe with same column names and i tried to append in a new row of same "res.csv" file but its appending again with columnnaes like first time when i created
2009 Jan 23
1
problem in appending data into*.csv file
Hi all, I got a problem with appending data into the *.csv file like abc<-read.csv("bbb.csv") # reading data from one csv file abc1<-mean(subset(abc,Group=="A")) hear i have to creat a .csv file and in that i have to create column's with names *group, mean* and farther i have to caliculate for Groups:-A, B, C, D, F and i have to append data to consicutive rows of
2009 Feb 19
4
problem with comparing a part of string with whole string
Hi all, I got one problem with comparing strings like if any string is like "*RIGHT, EPICARDIUM: FOCUS, GRAY-WHITE, SINGLE, APPROX 0.6 CM IN DIAMETER*." and i have to compare "*GRAY-WHITE*" with the above string or otherwise i have to compare " *TUMOR BENIGN*" this string with "*MEDULLRY TUMOR BENIGN,TYP PHEOCHROMOCYTOMA*" i
2009 Jan 07
1
problem with initialising R-Project through C#
Hi, i got a problem with initialising R-Project from C# in this i m sending what are all the code line I had been written and the error where i got sc1 = new STATCONNECTORSRVLib.StatConnector(); sc1.Init("R"); and error at SCN_E_INVALIDINTERPRETERVERSION -2147221487 0x80040011 can any one suggest how can i resolve it thanks & regards; kiran [[alternative HTML version
2009 Jun 05
1
problem with using subset from two different tables
Hi all, I am new to R-project my problem is I tried to get subset from two different tables its giving error but if i m tring for geting results from one table its working actually i have to take values from two tables with applying different conditions on two tables like kk- is an object of one table and fk- is an object of another table here i have to get values from these tables like
2009 Oct 09
1
problem with CPU usage
Hi all, I have a problem with CPU usage while running the Rgui.exe problem is while I am running scripts on Rgui its taking 100% of CPU is there any posibility to reduce the cpu consumption are any package I can use to reduce CPU consumption can any one help me out from this problem because while running these scripts I am not able to do any other work and there is no recursive functions and