Skip to content

Outil amélioré de comptage de l'évolution des points de charge IRVE #4335

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Draft
thbar wants to merge 10 commits into
base: master
Choose a base branch
from
Draft

Outil amélioré de comptage de l'évolution des points de charge IRVE #4335

Changes from 1 commit
Commits
Show all changes
10 commits
Select commit Hold shift + click to select a range
ce541c7
Create irve-count-faster.livemd
thbar Nov 20, 2024
c9f59d4
Merge branch 'master' into irve-history-count
thbar Nov 25, 2024
3b3247b
Update irve-count-faster.livemd
thbar Nov 25, 2024
58b6ca2
Update irve-count-faster.livemd
thbar Nov 25, 2024
c561ce3
Accelerate things a bit
thbar Nov 26, 2024
efcb2e5
Merge branch 'master' into irve-history-count
thbar Nov 26, 2024
1eee155
Merge branch 'master' into irve-history-count
thbar Dec 5, 2024
c7849c7
Merge branch 'master' into irve-history-count
thbar Dec 11, 2024
3d4efd7
Merge branch 'master' into irve-history-count
thbar Jun 26, 2025
14c8f0d
Merge branch 'master' into irve-history-count
thbar Jul 15, 2025
File filter

Filter by extension

Filter by extension
Conversations
Failed to load comments.
Loading
Jump to
Jump to file
Failed to load files.
Loading
Diff view
Diff view
Next Next commit
Create irve-count-faster.livemd
  • Loading branch information
@thbar
thbar committed Nov 20, 2024
commit ce541c7f0b7d75d005499286489474aa3b944c67
43 changes: 43 additions & 0 deletions livebook/irve-count-faster.livemd
View file
Open in desktop
Original file line number Diff line number Diff line change
@@ -0,0 +1,43 @@
# Suivi du nombre d'IRVE (version accélérée)

```elixir
Mix.install([
{:req, "~> 0.5.7"},
{:nimble_csv, "~> 1.2"},
{:kino, "~> 0.14.2"},
{:explorer, "~> 0.10.0"}
])
```

## Analyse

Je pars de la ressource [Fichier consolidé des bornes de recharge pour véhicule électrique](https://transport.data.gouv.fr/datasets/fichier-consolide-des-bornes-de-recharge-pour-vehicules-electriques).

Je récupére l'identifiant du dataset (`118`) et je m'appuie sur l'url qui retourne l'historique.

Reesource pour filtre:

* https://transport.data.gouv.fr/resources/81623

```elixir
history_url = "https://transport.data.gouv.fr/datasets/118/resources_history_csv"
%{status: 200, body: data} = Req.get!(history_url)
[headers | rows] = data

require Explorer.DataFrame

data = rows
|> Enum.map(fn row -> Enum.zip(headers, row) |> Map.new() end)
|> Enum.map(fn row -> Map.update!(row, "inserted_at", fn(x) ->
String.slice(x, 0..9) |> Date.from_iso8601!()
end) end )
|> Enum.reject(fn(row) -> row["permanent_url"] =~ ~r/\.json$/ end)

data
|> Enum.with_index()
|> Enum.map(fn {row, index} -> Map.put(row, "index", index) end)
|> Explorer.DataFrame.new(dtypes: [{"inserted_at", :date}])
#|> Explorer.DataFrame.filter(resource_id == "81623")
|> Explorer.DataFrame.discard(["payload", "resource_history_id", "resource_id"])
|> Kino.DataTable.new
```