I made an analysis for the audience and affiliations of the Partido Libertario Mx. Some of the insights are clearly explained in the conclusions page. Watch the entire visualization online here
You can start by reading the results or go directly to the table of contents.
All of the results are explicitly written in the presentation. The orange color means that those are the conclusions.
TRANSLATION
- Mexico's center: Mexico city, Mexico's State, Hidalgo, Queretaro, Guanajuato, will be the cradle of libertarianism in Mexico. We must start to hold public events and grouping our affiliates there to grow the affiliates on each state and start to formalize the organization.
- We need more female audience, the proportion of males is too high, so it is a must to propose actions congruent with female audiences, liberal feminism is one of those.
- The events with libertarian public figures are the best we can hold, they attract many people, so we must do two things, try to hold more events with them and develop our own intern personal brands on libertarianism.
- To take our internal personal brands to make content for us.
- Our best states outside the Mexico's center are industrial states so in the future those will be our levers to grow.
Some other visualizations with insights in orange color.
The events when we had the most affiliates were months that match good reach on facebook like Gloria and Milei on February 2021
The actual facebook audience is dominated by male 77.7%, our best age range are males between 25-34, same range for women
- Audience and Affiliations with Tableau
- Results
- Tools And Libraries
- Data Wrangling
- Python 3.7
- Pandas 1.1.5
- Numpy 1.19.5
- Datetime
- Excel
- Tableau
The wrangling was done on the master file I use to clean their data, the title you should look for is Afiliaciones there I clean the data, to see the entire document and more in detail comments I added click if the document don't open reload or download and open it with Google Colab.
Trying to skip some code lines after realizing this was going to be repetitive.
In the future I should convert this entire code into a function and also add more regex. Anyway I was kind of burned out at that time to think on a better solution, this worked and cleaned the entire dataset, and also it can work as a script.
Deleting affiliates from other countries than Mexico, skipping some lines of codes for Baja California and saving the file
