I have a column of age values from dataset that I need to convert to age ranges of 18-29, 30-39, 40-49, 50-59, 60-69, and 70+:
and i want it like this:
Anyone can help me. Thanks
The easiest way to do this is map
with a bunch of if-else
conditions.
julia> df = DataFrame(age = [81, 42, 18, 55, 23, 35]);
julia> function bin_age(age)
if age > 70
"70+"
elseif age > 60
"60-69"
elseif age > 50
"50-59"
elseif age > 40
"40-49"
elseif age > 30
"30-39"
elseif age > 20
"20-29"
elseif age > 10
"10-19"
end
end;
julia> df.agerange = bin_age.(df.age);
julia> df
6×2 DataFrame
Row │ age agerange
│ Int64 String
─────┼─────────────────
1 │ 81 70+
2 │ 42 40-49
3 │ 18 10-19
4 │ 55 50-59
5 │ 23 20-29
6 │ 35 30-39
3 Likes
thankyou so much, this way is very useful for me
For more general binning, see: