Platform
Resources
Pricing
Sign in
Get started
Ludovic C
Workspace
Fork
Public
By
Ludovic C
Edited
Feb 13, 2023
Insert cell
Insert cell
DP_D1076EY083_2022_S52@1.tsv
Filter
Columns
Sort
Slice
Save
Type Table, then Shift-Enter. Ctrl-space for more options.
Insert cell
Insert cell
Insert cell
Insert cell
function
sumi
(
values
,
index
)
{
let
sum
=
0
;
for
(
let
i
=
0
,
n
=
index
.
length
;
i
<
n
;
++
i
)
{
const
v
=
+
values
[
index
[
i
]
]
;
if
(
v
)
sum
+=
v
;
}
return
sum
;
}
Insert cell
Mnt_DP
=
DP
.
filter
(
(
d
)
=>
+
d
.
Date_DP_Paiement
>
date
(
"2021/12/31"
)
)
.
map
(
(
d
)
=>
d
.
Mnt_DP
)
Insert cell
DP2022
=
DP
.
filter
(
(
d
)
=>
+
d
.
Date_DP_Paiement
>
date
(
"2021/12/31"
)
)
.
map
(
(
d
)
=>
d
.
Date_DP_Paiement
)
Insert cell
group
(
DP2022
.
map
(
(
d
)
=>
+
d
)
,
(
i
)
=>
sumi
(
Mnt_DP
,
i
)
)
Insert cell
Purpose-built for displays of data
Observable is your go-to platform for exploring data and creating expressive data visualizations. Use reactive JavaScript notebooks for prototyping and a collaborative canvas for visual data exploration and dashboard creation.
Try it for free
Learn more
Fork
View
Export
Edit
Add comment
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
DP
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
File attachments
DP_D1076EY083_2022_S52@1.tsv
Databases
Filter
Column
Operator
Columns
Sort
Column
Direction
Descending
Ascending
Slice
From
Start
To
End
group
Edit
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
letter2offset
Edit
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
date
Edit
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
sumi
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
Mnt_DP
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
DP2022
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
Add comment
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML