Import data into R with an unknown number of columns?

by

There is nice function count.fields (see help) which counts number of column per row:

count.fields("test", sep = "\t")
#[1] 1 2 3 4 5 6 7 8

So, using your second solution:

no_col <- max(count.fields("test", sep = "\t"))
data <- read.table("test",sep="\t",fill=TRUE,col.names=1:no_col)
data
#   X1 X2 X3 X4 X5 X6 X7 X8
# 1  1 NA NA NA NA NA NA NA
# 2  1  2 NA NA NA NA NA NA
# 3  1  2  3 NA NA NA NA NA
# 4  1  2  3  4 NA NA NA NA
# 5  1  2  3  4  5 NA NA NA
# 6  1  2  3  4  5  6 NA NA
# 7  1  2  3  4  5  6  7 NA
# 8  1  2  3  4  5  6  7  8

More Related Contents:

  1. Quickly reading very large tables as dataframes
  2. Only read selected columns
  3. How can I read multiple (excel) files into R? [duplicate]
  4. How can you read a CSV file in R with different number of columns
  5. How do I import a CSV file in R? [closed]
  6. How to avoid: read.table truncates numeric values beginning with 0
  7. Reading multiple csv files from a folder into a single dataframe in R [duplicate]
  8. How to check if CSV file has a comma or a semicolon as separator?
  9. Issue when importing dataset: `Error in scan(…): line 1 did not have 145 elements`
  10. import dat file into R
  11. Preserving large numbers
  12. How to read.table() multiple files into a single table in R?
  13. Trying to merge multiple csv files in R
  14. Count number of rows within each group
  15. Create an empty data.frame
  16. Add a common Legend for combined ggplots
  17. Assign multiple new variables on LHS in a single line
  18. Where does R store packages?
  19. How to add a ggplot2 subtitle with different size and colour?
  20. Last Observation Carried Forward In a data frame? [duplicate]
  21. different size facets proportional of x axis on ggplot 2 r
  22. Extract file extension from file path
  23. How to change positions of x and y axis in ggplot2
  24. Add values to a reactive table in shiny
  25. Error with select function from dplyr
  26. How to assign from a function with multiple outputs? [duplicate]
  27. Manipulating files with non-English names in R
  28. How can I automatically create n lags in a timeseries?
  29. remove text after final period in string
  30. How to get a barplot with several variables side by side grouped by a factor

Leave a Comment