similar to: Error reading a table

Displaying 20 results from an estimated 8000 matches similar to: "Error reading a table"

2008 Jul 01
3
Ignore blank columns when reading a row from a table
Hi, I am extracting data from a table where the rows have different column lengths, and empty columns have NA in them. Whenever I extract a row with some empty columns, the resulting vector carries all the NAs. Is there a way to ignore the empty columns? Thanks, -Nina
2008 Jun 30
4
Problem reading a CSV
Hi, I have a CSV file where each row has at least 20 columns and some rows have up to 30 columns of data. When I use the command, Pathways<-read.table('MetaCycSample3.csv',sep=',',header=FALSE,quote='"') anything past the 21st column gets kicked down to a new row. How can I fix this? Thanks, -Nina
2008 Jul 01
3
Change name of a specific column of a data frame
Hi, Sorry for the simple question. Is there a way to change the name of only one column of an existing data frame? I know colnames allows you to set the name of all the columns, but only one column in the middle of my data frame needs a new name. Thanks, -Nina
2008 Jul 02
2
Problem reading from a data frame
Hi, I have a data frame with strings that have two letters and four numbers. When I store a whole row as a new vector and try to remove the preceding letters using the gsub command, it returns characters of single numbers that have no relation to the numbers in each string. I also noticed that when I view the new vector before using gsub, it includes the original headers from the data frame. For
2008 Jul 17
3
Display variables when running a script
Hi, I know this must be a stupid question, and sorry in advance for being such a noob. But, is there way to get R to display only certain variables when running a script. I know if you want to see the value of a variable when using the interface, you just type it in and hit enter, but is there a command that I can use in a script file that will show the value at a certain point? Thanks, -Nina
2008 Jul 22
2
Decoding subscripts/superscripts from CSVs
Hi, I have a CSV file with various biological reactions. Subscripts, superscripts, and italics are encoded in carats, and I was wondering if R can actually recognize those and print actual superscripts, etc. Here's an example: <i>S</i>-adenosyl-L-methionine + rRNA = <i>S</i>-adenosyl-L-homocysteine + rRNA containing
2008 Sep 04
1
read.table error
Dear all, I have a tab-delimited text (.txt) file which I'm trying to read into R. This file is of column format - there are in fact 3 columns and 259201 rows (including the column headers). I've been using the following commands, but receive an error each time which prevents the data from being read in: > Jan <- read.table("JanuaryAvBurntArea.txt", header=TRUE) Error in
2008 Jul 24
2
Help with which()
Hi, I'm using which to find the position of a value in my data table, and it is returning the correct position and the position of another number that differs by an extra decimal place. For example, when I do: where1<-which(Operons==3573.1,arr.ind=TRUE) it returns the position of that number and of 3573.15. Is it possible to get the function to only return a position if the number
2008 Jul 30
2
problem with read.table()
Hello R-User I have a table as tab-delimited textfile (291 rows, 83 columns). The first row are labels and the first line the variable names. I used the following code several times with different similar tables and it always worked. But now: setClass("of") setAs("character", "of", function(from) as.ordered(from)) Classe82<-cclasses <-
2009 Nov 10
3
Error: cannot allocate vector of size...
I'm trying to import a table into R the file is about 700MB. Here's my first try: > DD<-read.table("01uklicsam-20070301.dat",header=TRUE) Error: cannot allocate vector of size 15.6 Mb In addition: Warning messages: 1: In scan(file, what, nmax, sep, dec, quote, skip, nlines, na.strings, : Reached total allocation of 1535Mb: see help(memory.size) 2: In scan(file, what,
2007 Sep 06
2
problems in read.table
Dear R-users, I have encountered the following problem every now and then. But I was dealing with a very small dataset before, so it wasn't a problem (I just edited the dataset in Openoffice speadsheet). This time I have to deal with many large datasets containing commuting flow data. I appreciate if anyone could give me a hint or clue to get out of this problem. I have a .dat file
2008 Jun 11
1
Search entire table for a value
Hi, I have a table of numbers without any repeats. Is there a function that will search the entire table for a specified value and return the indices if it is found? Also, some rows may have columns without values. Thank you so much, -Nina
2008 Jun 18
1
Extract only certain rows from a table
Hi, I have a table where column 1 has ID numbers and column two has data, and I have a vector containing a subset of those ID numbers. How can I create a new table with only the rows from the old table that match the IDs in the vector, like below: Original Table: ID Value 1 123 2 123 3 123 4 123 vect: [2, 3] New table: ID Value 2 123 3 123
2008 Sep 19
4
Novice question about getting data into R
I found it easy to use R when typing data manually into it. Now I need to read data from a file, and I get the following errors: > refdata = > read.table("K:\\MerchantData\\RiskModel\\refund_distribution.csv", header > = TRUE) Error in scan(file, what, nmax, sep, dec, quote, skip, nlines, na.strings, : line 1 did not have 42 elements > refdata = >
2007 Jun 18
2
to read table
Hello, I have a problem to read a csv table. To read it I used this syntax > donParCara <- read.table("C:/Documents and Settings/melyakhlifi/Mes documents/feuilles excel/calcul2.csv",header=TRUE,sep=";",quote="",dec=",") I don't understand my errors Erreur dans scan(file, what, nmax, sep, dec, quote, skip, nlines, na.strings, : la
2013 Nov 18
1
Reading in csv data with ff package
I've spent some time trying to wrap my head around reading in large csv files with the ff-package. I think I know how to do it, but am bumping into some problems. I've tried to recreate the issues as best as I can with a smaller example and maybe someone can help explain the problems. The following code just creates a csv file with an integer column, character column and logical column.
2008 Jun 11
1
read.table() causes segfault with incorrect data (PR#11627)
Full_Name: Juho Vuori Version: 2.7.0 (2008-04-22) OS: Linux poseidon.fimr.fi 2.6.23.17-88.fc7PAE #1 SMP Thu May 15 00:22:53 EDT 2008 i686 i686 i386 GNU/Linux Submission from: (NULL) (193.166.188.194) Calling read.table() twice the following way causes a segmentation fault in R. Run R and type the following commands: > read.table(stdin()) 0: 1 2 3 1: 3 2: Error in scan(file, what, nmax, sep,
2008 Jun 10
1
Really simple question
Hi, I don't have too much programming experience - sorry in advance if this question is very basic, and thanks for the help. I have a vector of numbers and another vector of a subset of those numbers. How can I create a third vector with all the numbers in the original list that aren't in the given subset. Like this: List1 subset --> result 1 1 2 2 3 3 4
2008 Jul 14
1
Help with an error message
Hi, I am writing a very long program that deals with multiple large databases which often have missing data cells and other quirks. I've been testing it on small samples of the data so it doesn't take too long, but when I tried it using the real files, it ran for about a minute and then gave me this error message: Error in matrix(unlist(value, recursive = FALSE, use.names = FALSE), nrow
2008 Jul 30
1
Converting to subscripts and superscripts
Hi, I am reading in a CSV file of chemical reactions where the subscripts and superscripts are encoded in angle brackets, like below: 2 H<SUP>+</SUP> + 2 O<SUB>2</SUB><SUP>-</SUP> Is there a way to convert these to actual sub/superscripts and save them in another excel file? I greatly appreciate the help! Thanks, -Nina PS. I asked this before, but I