Split column into multiple columns

Question

I have data in a csv file in a single column with 6954 values. I want to split this column into multiple columns such that each column has 122 data and next column has the next 122 data and so on. I guess, I will have a final matrix of 122 rows and 57 columns. Any help will be appreciated.

Thanks

Use read.csv to read in comma-seperated value files: stat.ethz.ch/R-manual/R-devel/library/utils/html/…. — lukeA
– lukeA, Commented Feb 21, 2014 at 10:42

Victorp · Accepted Answer · 2014-02-21 10:43:05Z

3

Like this ?

x <- rep(1:122, 5)
xx <- matrix(x, nrow=122)
xx[1:5, ]
     [,1] [,2] [,3] [,4] [,5]
[1,]    1    1    1    1    1
[2,]    2    2    2    2    2
[3,]    3    3    3    3    3
[4,]    4    4    4    4    4
[5,]    5    5    5    5    5

answered Feb 21, 2014 at 10:43

Victorp

13.9k2 gold badges53 silver badges56 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

asb · Accepted Answer · 2014-02-21 12:25:20Z

1

Or this will do the trick as well:

x = 1:6954
dim(x) <- c(122, 57)

answered Feb 21, 2014 at 12:25

asb

4,4321 gold badge24 silver badges30 bronze badges

Comments

Hobo · Accepted Answer · 2016-05-16 01:53:01Z

1

A column can be split using the colsplit function which is part of the reshape package http://r.ramganalytics.com/r/split-a-column-by-a-character-using-colsplit-function/

edited May 16, 2016 at 1:53

Hobo

7,6215 gold badges44 silver badges52 bronze badges

answered Jul 3, 2014 at 10:18

user3801166

111 bronze badge

Collectives™ on Stack Overflow

Split column into multiple columns

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related