There are 22,289 records (lines) each with a column for zip code and DOB (date of birth). I need every record (22,289) represented in two separate charts. The first chart showing the distribution of zip codes, how many zip codes are represented and how many time each zip code is represented, and records without zip codes can be listed as "none"
The second chart should use the DOB column and show a total record count for birthdays within the date ranges as listed below <18, 18-24, 25-34, 35-44, 45-54, 55-64, 65+. Dates with "1900" for the year should be listed as "n/a" and not counted in the 65+ age range.
Solved by A. F. in 11 mins