tech:script_python_concersion_json_vers_csv
Différences
Ci-dessous, les différences entre deux révisions de la page.
| tech:script_python_concersion_json_vers_csv [2026/11/06 08:09] – créée Jean-Baptiste | tech:script_python_concersion_json_vers_csv [2026/11/06 08:14] (Version actuelle) – supprimée Jean-Baptiste | ||
|---|---|---|---|
| Ligne 1: | Ligne 1: | ||
| - | < | ||
| - | {{tag> | ||
| - | |||
| - | # Script Python concersion JSON vers CSV | ||
| - | |||
| - | ## Exemple 1 - 2 colonnes - clefs / valeurs | ||
| - | |||
| - | FIXME | ||
| - | |||
| - | ## Exemple 2 - liste de dictionnaires | ||
| - | |||
| - | Filtrage préliminaire du JSON | ||
| - | ~~~bash | ||
| - | cat Takeout/ | ||
| - | ~~~ | ||
| - | |||
| - | ~~~python | ||
| - | #! / | ||
| - | |||
| - | import sys | ||
| - | import json | ||
| - | import argparse | ||
| - | from datetime import datetime | ||
| - | |||
| - | parser = argparse.ArgumentParser( | ||
| - | epilog=""" | ||
| - | |||
| - | parser.add_argument(" | ||
| - | parser.add_argument(" | ||
| - | args = parser.parse_args() | ||
| - | |||
| - | def clean_field(field): | ||
| - | """ | ||
| - | Clean each fields. | ||
| - | CSV use ';' | ||
| - | CSV use line break as line separator and so all ' | ||
| - | """ | ||
| - | if field is None or field == " | ||
| - | ret = "" | ||
| - | else: | ||
| - | ret = str(field).strip().replace(";", | ||
| - | return ret | ||
| - | |||
| - | def quote_string(thing): | ||
| - | if isinstance(thing, | ||
| - | return '" | ||
| - | else: | ||
| - | return thing | ||
| - | |||
| - | def convert_json2csv(): | ||
| - | with open(args.i, | ||
| - | json_load = json.load(json_file) | ||
| - | with open(args.o, | ||
| - | headers = json_load[0] | ||
| - | print(';' | ||
| - | for elm in json_load: | ||
| - | newtime = elm[' | ||
| - | newtime = datetime.fromtimestamp(newtime) | ||
| - | elm[' | ||
| - | for v in elm.values(): | ||
| - | print(quote_string(clean_field(v)), | ||
| - | print(file=csv_file, | ||
| - | |||
| - | def truncate(): | ||
| - | with open(args.o, | ||
| - | csv_file.truncate(0) | ||
| - | |||
| - | def main(): | ||
| - | if args.i and args.o: | ||
| - | truncate() | ||
| - | convert_json2csv() | ||
| - | sys.exit(0) | ||
| - | |||
| - | |||
| - | if __name__ == " | ||
| - | main() | ||
| - | ~~~ | ||
| - | |||
| - | ~~~bash | ||
| - | ./ | ||
| - | ~~~ | ||
| - | |||
| - | |||
| - | ## Autres | ||
| - | |||
| - | ### Conversion CSV vers JSON | ||
| - | |||
| - | |||
| - | `man jc` | ||
| - | ~~~ | ||
| - | ... | ||
| - | --csv CSV file parser | ||
| - | |||
| - | --csv-ih | ||
| - | CSV implicit header file parser | ||
| - | |||
| - | --csv-s | ||
| - | CSV file streaming parser | ||
| - | |||
| - | --csv-ih-s | ||
| - | CSV implicit header file streaming parser | ||
| - | ... | ||
| - | ~~~ | ||
| - | |||
| - | ~~~bash | ||
| - | cat Historique.csv | jc --csv | ||
| - | ~~~ | ||
| - | |||
| - | FIXME | ||
| - | |||
tech/script_python_concersion_json_vers_csv.1793948940.txt.gz · Dernière modification : de Jean-Baptiste
