Data Analysis of MBTI Type

In this project, I have performed a simple Exploratory Data Analysis (EDA) to find out top careers of the MBTI personality type 'ESFP' (nicknamed The Entertainer)

The data was collected from personality database website that contains information related to personalities of famous people.

Data is loaded with pandas from an excel file that contains all the personality types data:

Afterwards, the data cleaning part is followed. Encoding is normalized so that there are no invalid characters in our data.

When viewing our data above, we see that there are similar careers that belong to one single category of careers. For example, 'Pop & Contemporary' and 'Kpop' belong to the same career i.e. 'Music'. We want to group all these careers together so that our final graph plots all the closely related careers as one. To do that, I have taken help from ChatGPT to put similar careers together with their respective general categories in a python dictionary and then use that dictionary to simplify the names.

Careers before generalizing names:

Careers after generalizing names:

There were still some records of people present in vague categories. So, I had to add them manually (ChatGPT comes to the resue once again!).

Here, we drop the data that has fictional/mythological figures. For that, I had already marked them for death removal with specific names.

Finally, we save all the 3145 rows of data into an excel file.

To plot a bar chart of percentage of mbti type vs career, I have created a script that can be reused for other personality types as well. Using that, we plot a bar chart of the top 5 careers found among the people of that personality type.

Conclusion:

By seeing the chart above, we can conclude that an overwhelming majority (>85%) of celebrities of the 'ESFP' mbti type belongs to the fields of entertainment (music, acting, sports, etc.). Unsurprisingly, this also justifies their title of being 'The Entertainer' type as well!

By following the same process, we can find out top/least popular professions for other types as well.