The retranscribed variable is “quantity_unit” (1,538 different values).
The file “Units_Normalisation_Orthographique.dta” establishes a correspondance between the variable “quantity_unit” and the variable “quantity_unit_ortho” (701 values). 210,000 observations have “livres” in “quantity_unit_ortho” and 160,000 have “unité manquante” (out of 510,000).
Simplification and single-key conversion
The file “Units_Normalisation_Métrique1” establishes a correspondance between the variable “quantity_unit_ortho” and either
– 1. the variables “quantity_unit_ajustees” (simplifying the “quantity_unit_ortho”), “u_conv” (a metric unit of quantity) and “q_conv” (the number of u_conv in “quantity_unit_ortho”). e.g. “quantity_unit_orth” “douzaine de paires” has “douzaine de paires” as “quantity_unit_ajustees”, “pièce” as u_conv and “24” as “q_conv”.
– 2. a variable “needs_more_details” which indicate that we cannot know the metric equivalent without using more variables.
Simplification and Multi-key conversion
The file “Units_Normalisation_Métrique2” establishes a correspondance between :
exportsimports + pays_grouping + direction + marchandises_simplification + quantity_unit_ortho and “quantity_unit_ajustees” (simplifying the “quantity_unit_ortho”), “u_conv” (a metric unit of quantity) and “q_conv” (the number of u_conv in “quantity_unit_ortho”).
Here is the document created by Matthias Loise to document the first version of the datascape. It can be used as a guide to the second one.
How to use the Datascape
Thanks to the hard work of Samuel Frémondière, Paul Girard, Alexis Jacomy, Guillaume Plique… there is now a new version of the datascape with a transformed design and many new features. You can access it here.
That is not the last iteration of the design of the datascape, but we hope you will appreciate how much on an improvement it is !
Pierre Hollegien was an intern in the TOFLIT project from in 2015. He then produced some very interesting work on drug trade.
He then went and did a MSc in the London School of Economics where he produced a research paper on “Reinterpreting The Colonial Trade: France, Sugar and Dutch Disease”.
Here it is:
Hollegien – EH499-Candidate_number_15129
While Pierre Hollegien was an intern in the project, he wrote a research paper titled “Evolution of Medicinal Practices and Drugs Consumption”. Here it is :
Hollegien – Evolution of Medicinal Practices and Drugs Consumption
Pierre Hollegien was an intern in the project from April to August 2015. Here is his internship report.
Hollegien – Rapport de stage
Attending members : Loïc Charles, Béatrice Dedinger, Guillaume Daudin, Paul Girard, Guillaume Plique, Elisa Tirindelli
SciencesPo has an extra 800 € that will be used to hire and additional day from Alexis Jacomy.
We discuss the transfer of money from INED to SciencesPo.
# Aggregation python script
There is now a documentation a documentation on github, but it needs to be completed (https://github.com/medialab/toflit18_data/blob/prod/scripts/README.md)
We discuss how the datascape has advanced. Alexis will still work on it and Guillaume and Loïc need to add a bit of documentation / texts.
We will continue this work in January 2018.
We discuss the new version of Ricardo
That was the last official TOFLIT18 meeting ! Thank you to all who contributed (and will continue contributing…)