Count string lengths in pandas dataframe column

Question

I am exploring a large dataframe with an object (string) column (air) of varying lengths such as this small example.

I want to obtain a summary of the count of each string length such as for the example:

length  count
4       1
8       2
9       1

I tried with

df["aic"].str.len().nunique()

which returns 3 meaning there are two different lengths but I don't know which.

Thank you

user_7964527 · Answer

You can do

out = df.aic.astype(str).str.len().value_counts().reset_index()
Out[104]: 
   index  aic
0      8    2
1      9    1
2      4    1