Please write in python.The files county$\_$age$\_$dist.csv$,$ fips$\_$state.csv and fips$\_$county.csv contain

information about the age distribution of counties in selected brackets as well as names and FIPS

codes and additional information.

$($a$,$ i$)$ Merge all three data frames into one pandas.DataFrame object names with

appropriate column names. $($ii$)$ Remove the info column. Standardize column names and

entries to be capitalized according to spelling rules. Remove any preceding whitespace if present

for any entries. Run:

data.head$(4)$

$($b$)$ For each county and state, compute the proportion of elderly CPE and SPE $(65$ and older$)$ to

the total population as well as the proportion of young people CPY and SPY $(24$ or younger$).$

Add those values to the data frame. You may ignore all FIPS regions that are not in states. Run:

data.head $(4)$