StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POSize of dataset causing calculation errors
primarykey
Id
14676576
data
AcceptedAnswerId
14677945
AnswerCount
1
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2013-02-03T19:52:57.340
FavoriteCount
0
LastActivityDate
2013-02-03T22:14:41.750
LastEditDate
2017-05-23T10:32:00.593
LastEditorUserId
-1
OwnerUserId
1968484
ParentId
0
PostTypeId
1
Score
1
ViewCount
1252
LastEditorDisplayName
text
Body
I have modified this code below from a <a href="https://stackoverflow.com/questions/14631548/efficiency-of-transforming-counts-to-percentages-and-index-scores">previous question I asked</a>: <pre><code>Input_Data <- read.csv("http://dl.dropbox.com/u/58164604/Input_Data.csv", row.names=1, stringsAsFactors = FALSE) TPop<-Input_Data[1] TPopCount <- TPop[, 1] TPopSum <- sum(TPopCount) OACRaw<-Input_Data[,4:ncol(Input_Data)] OACRawCount <-ncol(OACRaw) OA_Percentage <- TPopCount/TPopSum * 100 Data_Per_Row <- OACRaw/matrix(rep(TPopCount, each=OACRawCount), ncol=OACRawCount, byrow=T)*100 Data_Index_Row <- Data_Per_Row/OA_Percentage * 100 names(Data_Per_Row) <- names(Data_Index_Row) <- names(OACRaw) </code></pre> However, when I try and get it to work for a larger dataset (186 columns and over 180,000 rows) it gives the following error: <pre><code>Error in FUN(left, right) : non-numeric argument to binary operator </code></pre> However when the same code is run a smaller dataset (46 columns and 180,00 rows) it works fine: <pre><code>Input_Data <- read.csv("http://dl.dropbox.com/u/58164604/Input_Data.csv", row.names=1, stringsAsFactors = FALSE) TPop<-Input_Data[1] TPopCount <- TPop[, 1] TPopSum <- sum(TPopCount) OACRaw<-Input_Data[,4:50] OACRawCount <-ncol(OACRaw) OA_Percentage <- TPopCount/TPopSum * 100 Data_Per_Row <- OACRaw/matrix(rep(TPopCount, each=OACRawCount), ncol=OACRawCount, byrow=T)*100 Data_Index_Row <- Data_Per_Row/OA_Percentage * 100 names(Data_Per_Row) <- names(Data_Index_Row) <- names(OACRaw) </code></pre> Can anyone explain why this is and how I can get this code to work on a larger dataset? Thanks
Tags
<r><error-handling><dataset><limit>
Title
Size of dataset causing calculation errors
singulars
PostAcceptedAnswerId
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USCommunity
UserOwnerUserId
1. USChris
plurals
PostLinksPostIdRelatedPostId
1. PL
 singulars
 LinkTypeLinkTypeId
 LTLinked
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 POSize of dataset causing calculation errors
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.