Question

In what year did the birthrate peak?

Answer 1

I don’t have the data or chart you’re looking at. Which country/dataset/time period do you mean? If you can share the data (or the chart), I’ll find the year for you.

If you want to do it yourself, here are quick methods:

- Python (pandas)
- Single year (first max): year = df.loc[df['birthrate'].idxmax(), 'year']
- All years if tied: df[df['birthrate'] == df['birthrate'].max()]['year'].tolist()

- R
- Single year: df$year[which.max(df$birthrate)]
- All years if tied: df$year[df$birthrate == max(df$birthrate)]

- SQL
- SELECT year FROM births WHERE birthrate = (SELECT MAX(birthrate) FROM births);

- Excel
- Find row: =MATCH(MAX(B:B), B:B, 0) (assuming years in A, rates in B)
- Then get year: =INDEX(A:A, MATCH(MAX(B:B), B:B, 0))

Tell me where the data is or paste it here and I’ll return the peak year.