R: Iterate through excel file content readxl

Asked May 22 '17 at 16:23

Active May 22 '17 at 17:12

Viewed 103 times

require("readxl")
excelFile<-read_excel("C:/PathtoExcel.xlsx")

I want to iterate through the excelFile so I get each column's value in each row in the excel sheet how do I do that?

I want to do that for following problem:

I have an excel sheet with 3 columns and 163 rows. The data in each column's row is of type integer that can be 0 or greater. I want to go through Column's rows and count the number of consecutive 0s in a column. Let say I have a column

1 0 0 1 0 0 0 5 0 0 10

so the result would be (2 + 3 + 2 )/3 where 2, 3, 2 are the consecutive 0s in the column

edited May 22 '17 at 17:12

asked May 22 '17 at 16:23

hariszaman

8,202
2
40
59

If you explain in more detail why you would want to do this and what your ultimate goal is you're likely to get better answers. – joran May 22 '17 at 16:44
I updated the question – hariszaman May 22 '17 at 16:58
Perhaps editing your question would be a better way forward than trying to cram everything into the comments...? – joran May 22 '17 at 17:00
yeah sorry was trying to do that – hariszaman May 22 '17 at 17:02
You're going to want to read up on the function `rle()`. – joran May 22 '17 at 17:13
ok thanks but how do I get the column's data to be fed to rle()? – hariszaman May 22 '17 at 17:17
Something like `rle(excelFile$col)` or equivalently `rle(excelFile[["col"]])`. – joran May 22 '17 at 17:19
Let us [continue this discussion in chat](http://chat.stackoverflow.com/rooms/144859/discussion-between-hariszaman-and-joran). – hariszaman May 22 '17 at 17:24
Thanks for your help – hariszaman May 22 '17 at 17:34

R: Iterate through excel file content readxl

0 Answers0