Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Creating a histogram using aggregated data

Tags:

r

csv

histogram

Embarrassingly simple question...

I'm new to R and I can't seem to wrap my head around this for some reason. I have a CSV file which looks something like this:

Bin,Number
1363,5
1028,4
1303,3
1467,1
1242,3
1415,5
..
.

The bin size is 1, with a range of 1000-1500. I have read my CSV file in, everything seems to be ok there, but I just cannot produce a simple histogram. I have tried simply using a barplot, but the data is not numerically ordered, so will not produce the output I need. Using data such as this, how can I produce a histogram in R?

Once I have a simple histogram, I'm sure I'll be able to play around with it and format it nicely.

like image 928
user2941526 Avatar asked Oct 25 '25 14:10

user2941526


1 Answers

Because the hist function does the counting of items in each bin, you need to 'explode' your 'already counted' data, for example by using rep. Then you can use hist on the resulting vector.

with(df, hist(rep(x = Bin, times = Number)))
like image 106
Henrik Avatar answered Oct 28 '25 02:10

Henrik