Qualify your audience on Twitter (part 2/2)

I described in a previous post how we can extract a network of followers on Twitter, and identify the communities to which they belong. This step allowed me to identify 6 communities: Geographers, a community from the Parisian Economy, a group of girls who are coding,…

A disinformation campaign in Germany?

Sperm crisis and endocrine disrupters: a disinformation campaign in Germany? On July 25, 2017 Levine (et al.) published an international meta-analysis, summarizing the results of 185 scientific papers on sperm counts since 1973. The results of this study are alarming….

Qualify your audience on Twitter (part 1/2)

Have you already tried to qualify your audience on Twitter? Several tools already exist, but I have been curious to do it with the ones I already have; R to extract data, and for social network analysis, and Gephi to visualise my followers communities. In these…

Import SIRENE, the French database about companies, in PostgreSQL

SIRENE is the database about french companies that is produce by the French office of statistics: INSEE. This database has been opened in January 2017 and wasn’t for free until there. It contains more than 10 millions of entries, reason why I’m storing it in PostgreSQL. I’m explaining the steps to import it in this post.