How to export spreadsheet data to GNU R for statistical analysis ?

More Alexander V. Perig's questions See All

Which mathematical techniques it is possible to apply to simulation of academic journal publishing processes ?

I'm thinking about a paper concerning mathematical simulation of processes of journal selection - review - correction - publication - indexation of journal's published manuscript. I wonder which...

05 June 2018 8,751 1 View

What is wrong with modern society and modern social sciences, which are simply helpless in educational practice ?

20 February 2018 I have seen very unpleasant phenomenon near five-storey blocks of flats where I live. There was a group of 10-15 local boys-teenagers, who chorus sang a popular Russian song "It...

01 February 2018 5,286 48 View

How researcher has to publish his/her new results if publisher mechanically uses iThenticate without reading article & novelty?

There are researchers who study one and the same class of problems for all his/her life. And how this researcher has to publish his/her new results if publisher mechanically uses iThenticate...

07 August 2016 6,775 1 View

How to learn more about SPSS and its Application?

I would like to learn more about SPSS and Its application especially in regards to data analysis. Please suggest me how I can learn more about it. Thank you so much.

11 August 2024 9,101 4 View

Can I base on reverse DNA sequences to perform alignment, convert to amino acids and GenBank submission?

I have reverse sequences (AB1 format), can I base on reverse DNA sequences to perform nucleotide alignment, convert nucleotides to amino acids and deposit the sequence in GenBank database?

11 August 2024 5,138 1 View

Baseline drift in HPLC? What causes this?

Hello, Why do i see this baseline drift when i compare my blank (black) to the sample (blue)? Any suggestions as to why this happened? Thank you!

11 August 2024 3,770 4 View

Text-Communication from the M1 Hand Area using BCI—and then there is Elon Musk?

Willett, Shenoy et al. (2021) have developed a brain computer interface (BCI) that used neural signal collected from the hand area of the motor cortex (area M1) of a paralyzed patient. The...

10 August 2024 7,180 0 View

Has anyone applied Python in the field of textile engineering for data analysis, automation, or smart textiles?

I'm currently exploring the application of Python in textile engineering, specifically in areas like data analysis, process automation, and the development of smart textiles. I'm interested in...

10 August 2024 7,429 2 View

How can I use the cif data obtained from rietveld refinement extracted via gsas2, for microstructural analysis using ETEX software?

09 August 2024 7,718 0 View

How are iso-frequency contours plotted?

Let's say we have a standard, regular hexagonal honeycomb with a 3-arm primitive unit cell (something like the figure attached; the figure is only representative and not drawn to scale). The...

07 August 2024 1,937 1 View

How to prepare the nanoparticle treated fungal sample for Environmental SEM analysis?

A fungal strain was treated with nanoparticles. We want to do an environmental SEM analysis. So could anyone share your views on preparing the sample? Thank you.

07 August 2024 5,307 1 View

How to normalize and take the significance of the MTT OD values with 3 replicates for the same cell-line?

Hi, I have a question about normalizing the MTT OD values for doing the statistical analysis. So, if we have 3 different plates and we call them 3 different replicates, so, first we would...

07 August 2024 8,106 4 View

Is there an alternative to a multinomial regression which allows the DV to be non mutually exclusive?

I am trying to analyse data from a survey examining what variables affect teachers perceived barriers to incorporating technology into their classroom. I have 5 predictor variables however my DV...

06 August 2024 1,752 3 View

Nishal Kumar

http://www.r-tutor.com/r-introduction/data-frame/data-import

The above tutorial might be helpful in loading spreadsheet data in R .

Jochen Wilhelm

Not mentioned in the tutorial linked by Nishal is the library "xlsx" and read.xlsx(). It reads both xls and xlsx files and does not require a Perl runtime installation.

Onother packege is "XLConnect" and the fuction readWorksheetFromFile().

Further links:

http://www.milanor.net/blog/?p=779

http://cran.r-project.org/doc/manuals/r-release/R-data.html

Jan Breitschuh

Are we talking about large (6M) or huge (6G) sheets? Typically you may import from CSV, XLS or SPSS. What will be your favourite?