search

medialab / toflit18_data

Datapackage for TOFLIT18 research project
4 stars 1 forks source link

Attention au passage de Rennes 1714 dans Json #17

Open gdaudin opened 6 years ago

gdaudin commented 6 years ago

Les années sont "Janvier 1714, Février 1714, etc." À traiter comme "1714" dans tous les cas.

gdaudin commented 6 years ago

Finalement, on laisse tomber.

gdaudin commented 6 years ago

Idéalement, il faudrait faire la somme...

gdaudin commented 6 years ago

insheet using "/Users/guillaumedaudin/Documents/Recherche/Commerce International Français XVIIIe.xls/Balance du commerce/Retranscriptions_Commerce_France/toflit18_data_GIT/sources/Local - out/Rennes - Sorties - 1714.csv", clear replace year="1714" replace value =usubinstr(value,",",".",.) replace quantit =usubinstr(quantit,",",".",.) destring, replace duplicates report marchandises duplicates report marchandises pays duplicates report dataentryby source sourcepath sourcetype exportsimports marchandises pays collapse (sum) quantit value, by(source-exportsimports year marchandises direction pays quantity_unit prix_unitaire probleme remarks doubleaccount) replace sourcepath ="Local/Rennes/Rennes - Sorties - 1714 - reconstructed.csv" export delimited using "/Users/guillaumedaudin/Documents/Recherche/Commerce International Français XVIIIe.xls/Balance du commerce/Retranscriptions_Commerce_France/toflit18_data_GIT/sources/Local/Rennes/Rennes - Sorties - 1714 - reconstructed.csv", replace insheet using "/Users/guillaumedaudin/Documents/Recherche/Commerce International Français XVIIIe.xls/Balance du commerce/Retranscriptions_Commerce_France/toflit18_data_GIT/sources/Local - out/Rennes - Entrées - 1714.csv", clear replace year="1714" replace value =usubinstr(value,",",".",.) replace quantit =usubinstr(quantit,",",".",.) destring, replace collapse (sum) quantit value, by(source-exportsimports year marchandises direction pays quantity_unit prix_unitaire probleme remarks) replace sourcepath ="Local/Rennes/Rennes - Entrées - 1714 - reconstructed.csv" export delimited using "/Users/guillaumedaudin/Documents/Recherche/Commerce International Français XVIIIe.xls/Balance du commerce/Retranscriptions_Commerce_France/toflit18_data_GIT/sources/Local/Rennes/Rennes - Entrées - 1714 - reconstructed.csv", replace

gdaudin commented 6 years ago

Script Stata