Hard Core
2012-Nov-26 10:20 UTC
[R] How to count the number of different elements in a column
Hello, Suppose that i have a dataframe a <- read.dta("banca_impresa.dta") i have a column with 17900 obs like 1 2 3 1 6 7 8 3 4 4 and i want to know the number of the different values so in this case it would be 7 How can i do? Thank you -- View this message in context: http://r.789695.n4.nabble.com/How-to-count-the-number-of-different-elements-in-a-column-tp4650825.html Sent from the R help mailing list archive at Nabble.com.
chuck.01
2012-Nov-26 13:29 UTC
[R] How to count the number of different elements in a column
length(unique(a)) Hard Core wrote> Hello, > Suppose that i have a dataframe > a <- read.dta("banca_impresa.dta") > > i have a column with 17900 obs like > > 1 > 2 > 3 > 1 > 6 > 7 > 8 > 3 > 4 > 4 > > and i want to know the number of the different values so in this case it > would be 7 > How can i do? > Thank you-- View this message in context: http://r.789695.n4.nabble.com/How-to-count-the-number-of-different-elements-in-a-column-tp4650825p4650833.html Sent from the R help mailing list archive at Nabble.com.
Sarah Goslee
2012-Nov-26 16:41 UTC
[R] How to count the number of different elements in a column
> x <- c(1, 2, 3, 1, 6, 7, 8, 3, 4, 4) > length(unique(x))[1] 7 On Mon, Nov 26, 2012 at 5:20 AM, Hard Core <gioxc at hotmail.it> wrote:> Hello, > Suppose that i have a dataframe > a <- read.dta("banca_impresa.dta") > > i have a column with 17900 obs like > > 1 > 2 > 3 > 1 > 6 > 7 > 8 > 3 > 4 > 4 > > and i want to know the number of the different values so in this case it > would be 7 > How can i do? > Thank you > >-- Sarah Goslee http://www.functionaldiversity.org
Jose Iparraguirre
2012-Nov-26 16:44 UTC
[R] How to count the number of different elements in a column
Hi, Imagine the column is named XX. Type:> nrow(table(banca_impresa$XX))and you'll get how many different categories there are in that column. (If you type> table(banca_impresa$XX)you'll get the frequencies). Jos? Jos? Iparraguirre Chief Economist Age UK T 020 303 31482 E Jose.Iparraguirre at ageuk.org.uk -----Original Message----- From: r-help-bounces at r-project.org [mailto:r-help-bounces at r-project.org] On Behalf Of Hard Core Sent: 26 November 2012 10:20 To: r-help at r-project.org Subject: [R] How to count the number of different elements in a column Hello, Suppose that i have a dataframe a <- read.dta("banca_impresa.dta") i have a column with 17900 obs like 1 2 3 1 6 7 8 3 4 4 and i want to know the number of the different values so in this case it would be 7 How can i do? Thank you -- View this message in context: http://r.789695.n4.nabble.com/How-to-count-the-number-of-different-elements-in-a-column-tp4650825.html Sent from the R help mailing list archive at Nabble.com. ______________________________________________ R-help at r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code. A Star for Christmas Kick start the festive season by attending one of Age UK?s Carol Concerts, A Star for Christmas. Taking place at Manchester Cathedral on Saturday 1 December and London?s St Pancras Church (opposite Euston Station) on Thursday 6 December, they will feature special musical performances, readings by your favourite celebrities and carols, followed by mince pies and wine. Tickets are priced at ?20 full price/ ?10 concessions. For more information, please visit http://www.ageuk.org.uk/astarforchristmas or contact the Fundraising Events Team on 020 303 31725. Age UK Improving later life www.ageuk.org.uk ------------------------------- Age UK is a registered charity and company limited by guarantee, (registered charity number 1128267, registered company number 6825798). Registered office: Tavis House, 1-6 Tavistock Square, London WC1H 9NA. For the purposes of promoting Age UK Insurance, Age UK is an Appointed Representative of Age UK Enterprises Limited, Age UK is an Introducer Appointed Representative of JLT Benefit Solutions Limited and Simplyhealth Access for the purposes of introducing potential annuity and health cash plans customers respectively. Age UK Enterprises Limited, JLT Benefit Solutions Limited and Simplyhealth Access are all authorised and regulated by the Financial Services Authority. ------------------------------ This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you receive a message in error, please advise the sender and delete immediately. Except where this email is sent in the usual course of our business, any opinions expressed in this email are those of the author and do not necessarily reflect the opinions of Age UK or its subsidiaries and associated companies. Age UK monitors all e-mail transmissions passing through its network and may block or modify mails which are deemed to be unsuitable. Age Concern England (charity number 261794) and Help the Aged (charity number 272786) and their trading and other associated companies merged on 1st April 2009. Together they have formed the Age UK Group, dedicated to improving the lives of people in later life. The three national Age Concerns in Scotland, Northern Ireland and Wales have also merged with Help the Aged in these nations to form three registered charities: Age Scotland, Age NI, Age Cymru.