PinnedJuan Felipe Alvarez JaramilloinThe StartupBeer Mining: Text Analytics with Pub names in UKEver since I arrived to UK to do my MSc studies, I have been interested in the Pub culture of this country. There is one Pub on the ground…Jul 11, 2019Jul 11, 2019
Juan Felipe Alvarez JaramilloMapping the UK’s phased reopening of hospitality industryThe UK government has recently (as of April 12th) relaxed some measures, allowing hospitality venues to serve clients in outdoor spaces…May 3, 2021May 3, 2021
Juan Felipe Alvarez JaramilloinDataDrivenInvestorWeb scraping, color analysis and funny names: Nail polish analyticsDuring the weekend I read an amazing blog entry about a nail polish name generator that uses a big dataset of scrapped names and color…Feb 1, 2021Feb 1, 2021
Juan Felipe Alvarez JaramilloPython meets Instagram — Applied Network Analytics + case studyFirst it was Facebook: the primal online tool that connected people and enabled them to build communities. Then, our online communications…Nov 13, 2020Nov 13, 2020
Juan Felipe Alvarez JaramilloMapping the UK and navigating the post code mazeIf you have read some of my blogs, you would already know that I love maps and visualising information geographically. That is why in my…Oct 15, 20201Oct 15, 20201
Juan Felipe Alvarez JaramilloGoogle search queries in the times of COVID-19Mass-extracting Google search trendsApr 30, 2020Apr 30, 2020
Juan Felipe Alvarez JaramilloCOVID-19 Trajectories monitoringThis article describes an online tool that I created. You can follow this link to interact with it; it is updated every day with new…Mar 27, 20201Mar 27, 20201
Juan Felipe Alvarez JaramilloTourism Flows: a definitive visualisationThis article describes an online tool that I created. You can follow this link to interact with it.Mar 11, 2020Mar 11, 2020
Juan Felipe Alvarez JaramilloShake it up! Network Analytics of Cocktail IngredientsNetwork theory studies the relations between entities; in other words it tries to reveal the different ways things are connected to each…Nov 21, 2019Nov 21, 2019
Juan Felipe Alvarez JaramilloVLOOKUP and INDEX/MATCH equivalences in PandasIn one of my previous blogs I tried to map the equivalences between Excel and Pandas for creating Pivot Tables. I am writing this new blog…Oct 29, 20192Oct 29, 20192