Question: Problem with saving all the whole data in R using biomaRt
0
gravatar for palaganiajay
11 months ago by
palaganiajay0 wrote:

I am new to R programming and have a question in saving the output file. I am unable to save all the data which consists of 4500 rows generated from R. It can only save the first 15 rows generated. Can someone please help me out with this.

below is the code which i used

> result<- getBM(attributes=attributes,filters=c("chromosome_name","start","end"),values=list(chrom,chr.start,chr.end),mart=ensembl)
> result
>write.xlsx(result,"/Users/ajaypalagani/Desktop/ajdat.xlsx")

Thank you Ajay

biomart R • 207 views
ADD COMMENTlink modified 11 months ago • written 11 months ago by palaganiajay0
1

Please show the first 16 rows of your data frame.

head(result, n=16)

Also, try to save it as a tab delim txt file instead of xlsx.

ADD REPLYlink modified 11 months ago • written 11 months ago by Benn8.0k

hi thank you for your reply.

I think i didn't post the question in a right way.

I am getting only first 15 rows of data and i need to export all the 4000 rows of data from R to excel.

Thanks, Ajay

ADD REPLYlink written 11 months ago by palaganiajay0
1

The question was clear the first time around. We just need more info in order to help you. For example, we need to see the first 16 rows of your data because the suspicion is that the parser goes wrong between the 15th and the 16th line. Also exporting in another format can help figure out where the problem lies.

ADD REPLYlink written 11 months ago by Jean-Karim Heriche22k

Do not 'add answer' to provide more info because this makes it look like your question is already answered. Use the 'add reply' button to reply to a request for info or 'add comment' to add something to the discussion that is not an answer.

ADD REPLYlink written 11 months ago by Jean-Karim Heriche22k
Please log in to add an answer.

Help
Access

Use of this site constitutes acceptance of our User Agreement and Privacy Policy.
Powered by Biostar version 2.3.0
Traffic: 1063 users visited in the last hour