For this assignment I worked in a project that evolved and get included in a larger one. I’m currently participating with my hometown university (ITESO) trying to understand what the newspapers are publishing related to political candidates, with elections for mayors and local congress in 60 days the team in Mexico is collecting the news related to the campaign every day.

With the news as a data set I processed it in Wordij a tool to generate semantic networks from .txt files, the software also gets a count of words in a csv file, this files where processed in Excel and then visualized in Tableau, with all the data we could run queries to know how many times a candidate has been mentioned by each newspaper, and adding data every day we are getting a larger picture of whom the newspapers are talking about.

As part of another project that I’m involved with to monitor the political campaigns, we decided to include the data-viz tool as part of the site, all the info is in spanish but if any one wants to try the tool you could use the right side panel, adjusting dates, frequency of words or search for specific words, for example search for “PRI” or “PAN” or “MC” political parties or for “Villanueva”, “Alfaro” or “Petersen” last name of the candidates. The visualization is here.

Visualization showing queries for “Alfaro”, “Villanueva” and “Petersen”