Jump to content

  • Log in with Facebook Log in with Twitter Log in with Windows Live Log In with Google      Sign In   
  • Create Account

Submit your paper to J Biol Methods today!
Photo
- - - - -

Problem managing big table in Excel


  • Please log in to reply
1 reply to this topic

#1 mohsamir1984

mohsamir1984

    member

  • Active Members
  • Pip
  • 11 posts
0
Neutral

Posted 09 December 2018 - 07:41 AM

Dear all, 

I have a big table in excel which contains 20 column and 93.000 rows. Now I can open the file as this is within the limit of excel. I would like to run a PCA plot using R program. This requires me to transpose this table meaning that I will contain 20 row and 93.00 column which is not possible in excel. 

Has any of you an idea to transpose this table using excel (by surpasing the limit) or by other program ? 

I was able to do this in R, but again you can not export the excel file to R, ans it gives an error message. 

 

Any help ? 



#2 bob1

bob1

    Thelymitra pulchella

  • Global Moderators
  • PipPipPipPipPipPipPipPipPipPip
  • 6,668 posts
565
Excellent

Posted 09 December 2018 - 11:59 AM

Excel is really not set up to do this sort of thing at all. Large data analysis is very difficult in excel, but R excels (pun intended) at it

 

You should be able to use the file in R - use as a minimum:

 

>install.packages("readxl")

>library(readxl)

 

>your_data <- read_excel("path\to\your\file.xlsx") 

 

Check out ?read_excel (or google it) if you want more information.

 

Transposing in R is quite simple - it's part of the base R packages, so should be already installed - have a look at the syntax using ?t in your R terminal/console. You may need to make your dataframe into a matrix:

 

>your_matrix <- as.matrix(your_data)

>transposed <- t(your_matrix)






Home - About - Terms of Service - Privacy - Contact Us

©1999-2013 Protocol Online, All rights reserved.