StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POSummarise data frame ignoring repetition
text
Body
copied!<p>I have a data frame in which there are repetitions of entries in one column. I want to summarize the other columns based on the that one column. I wish the summary to consider each unique entry and not the total count when making the summary. For example in the data frame example below, if i want to answer the question on <strong>how many people surveyed are young,midage and old?</strong> "RefID" 1-1 is taken as a count of 1 in summarising "ageclass"=young and not interpreted as a count of 5. </p> <pre><code>RefID Altitude Sex ageclass 1-1 Low F young 1-1 Low F young 1-1 Low F young 1-1 Low F young 1-1 Low F young 1-2 Low F midage 1-2 Low F midage 1-2 Low F midage 1-2 Low F midage 1-2 Low F midage 1-2 Low F midage 1-2 Low F midage 1-2 Low F midage 1-2 Low F midage 1-2 Low F midage 1-2 Low F midage 1-2 Low F midage 1-3 Low F old 1-3 Low F old 1-3 Low F old 1-3 Low F old 1-3 Low F old 1-3 Low F old 1-3 Low F old 1-3 Low F old 1-3 Low F old 1-3 Low F old 1-3 Low F old 1-3 Low F old 1-3 Low F old 1-3 Low F old 1-3 Low F old 1-3 Low F old 1-3 Low F old 1-3 Low F old 1-4 Low F old 1-4 Low F old 1-4 Low F old 1-4 Low F old 1-4 Low F old 1-4 Low F old 1-4 Low F old 1-4 Low F old 1-4 Low F old 1-4 Low F old 1-4 Low F old 1-4 Low F old 1-5 Low F old 1-5 Low F old 1-5 Low F old 1-5 Low F old 1-5 Low F old 1-5 Low F old 1-5 Low F old 1-7 Low F old 1-7 Low F old 1-7 Low F old 1-7 Low F old 1-8 Low F old 1-8 Low F old 1-9 Low F old 1-9 Low F old 1-9 Low F old </code></pre> <p>Thank You.</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload