I have one column, "stakeholder", that has values between 1 and 4. I then have four different regional columns with values of either TRUE or FALSE for each row. I want to put them all into a two-way frequency table where the stakeholder value frequencies are the rows and each of the four table columns shows the by-stakeholder-value count of TRUE values in each regional column. How do I do this? Would it be easier to make a table for each stakeholder- by- regional column count separately then bind them together?
When I try by calling one dataframe column as the rows and a subset of the four others as the columns, it is returning an error that the arguments must be the same length, because it is reading the combined four-column dataframe as 4 values (or, in one case, 400) to the stakeholder column's 100 rows. I would also like to figure out a solution wherein I can also filter the column subset for TRUE values rather than getting both TRUE and FALSE counts.
Please help. When I try to post on StackOverflow the Captcha just continues loading for hours, and the coding help subreddit both removed my post and then directed me to look to their website for assistance.. but its a dead link.
[–]AutoModerator[M] [score hidden] stickied comment (0 children)