The way we treat quantity units (as of February 26th 2018)

The retranscribed variable is « quantity_unit » (1,538 different values).

 Orthographic Normalization

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 »).

Pierre Hollegien, Reinterpreting The Colonial Trade: France, Sugar and Dutch Disease

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

December 19th 2017 meeting

Attending members : Loïc Charles, Béatrice Dedinger, Guillaume Daudin, Paul Girard, Guillaume Plique, Elisa Tirindelli

# Budget
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)

# Datascape
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.

# Ricardo
We discuss the new version of Ricardo

That was the last official TOFLIT18 meeting ! Thank you to all who contributed (and will continue contributing…)