Week 15: Pre Mortem

--Originally published at TC3045 – Sagnelli's blog

Some people say that time is money; however, I think that time is success.

The bad news is, time is running out. Teachers are actually being disrespectful and dropping more, and more homeworks while their projects are due in less than two weeks. Not much has changed from the previous blog post, but I am actually using this blog post as a stress reliever. Let’s hope my cards under my sleeve don’t run out.

Stay tuned for the next blog post, to see how this week developed.

Week 14 – Pre Mortem

--Originally published at TC3045 – Sagnelli's blog


We are almost at the end of this course; only two weeks left. Luckily, we already finished this project; however, I can already feel the stress of working with the pending 3 projects for other courses. Actually, we might use this course’s project as a starter for our Advanced Database course project. We are thinking on developing a web app that based on data displays a heat map of parties popularity among different zones. We are focusing on Jalisco, and parties competing for governor, and senator position.

Stay tuned on the developments of this week other projects.

Week 11 – PostMortem

--Originally published at TC3045 – Sagnelli's blog

Holy week is here, and I won’t be relaxing that much. I am preparing for a job interview. I will be focusing on working on my data structures, algorithms, and databases skills for the interview. I won’t be working on this project, so I won’t be blogging in Holy week.

On the other hand, this week we had our sprint presentation. We could say that the backend part of the application is almost finished. We must focus now on the frontend part of it.

Stay tuned, and see you on Easter week.

Week 10 Post-Mortem

--Originally published at TC3045 – Sagnelli's blog


This week I saw some great advancements on our project. Alfonso, and I finished styling the code for the words counting functionality of the word cloud. The graphic stuff is going to be developed in the front-end; however, the basic functionality of distinguishing which words are most frequently used by candidates is already done. We used a library from Python named Counter to do this. The current output of our word cloud program is a list of words with their respective number of appearances.

This is what we are going to present on the sprint presentation on Tuesday because on Friday the classrooms where occupied, so the presentation was moved.

Be sure to hear of what the next steps are going to be.

Week 8 Post-Mortem

--Originally published at TC3045 – Sagnelli's blog


This week I said I was going to work on eliminating stop words with Alfonso; however, I didn’t quite ended up doing that. What I did, was optimizing the code, to avoid repeating code. Henceforth, the code used for opening and reading a file into an array was made a static method accessible by all micro-services. This is a good practice to stop repeating unecessary lines of code.

Next week we will be having an intense work on Taller Vertical. I’ll update what I’ve done on the Taller Vertical, but I won’t be working on this project next week.


Week 4: Database & Python 4 life

--Originally published at TC3045 – Sagnelli's blog

What’s new, it’s Mike again.

This week is going to be about improving what I previously achieved on the project. I will fix the code, applying some better practices while coding, and I will add some functionalities. Reading, and deleting from the database shall be implemented. Also, I will try to store the tweets without modifying the text for further use on sentiment analysis. For this last part, everything matters; from emojis, to raw text. Henceforth, I will be researching how to store tweets with special characters, and emojis into the database.

This is what I will try to do, and I will keep learning about Python, MySQL, and all these new topics for me.

Stay tuned for what I achieve this week.

From now on, bad practices shall be avoided.

Week 3: PyMySQL is about to be applied

--Originally published at TC3045 – Sagnelli's blog

“When you want to succeed as bad as you want to breathe, then you’ll be successful.”

– Eric Thomas

Hey, I’m still awake. Now, there’s a reason to it, and as bad as I want that reason to be watching a Netflix series, or playing videogames, it is not. I am thinking on what I will be doing this week for the Elections Analyzer 2018 project.

This week is going to be all about creating generic functions in Python for DML queries on a MySQL database. I will be dividing this functions as micro-services. Henceforth, there is going to be a separate micro-service for inserting (creating), selecting (reading), updating, and deleting, (CRUD), from a generic database. Everything using the PyMySQL library.

Stay tuned for the post-mortem update of this week’s development.

Week 2: The beginning

--Originally published at TC3045 – Sagnelli's blog

As the title states, this week is where it all begins. We already know the objective, and how we are going to achieve it, so let’s dive into work.

Resultado de imagen para gif working

If you want to see our progress, you can by visiting our repo. This week is going to be about getting up and running with the database, and start structuring the python project.


  • Define microservices and divide functionalities.
  • Structure python project.
  • Getting up and running with the database.
  • Start developing with unit testing, and Agile methodology.

So, let’s begin…