Platform
Solutions
Resources
Pricing
Sign in
Sign up
Max Bo
Software Engineer @ Canva, ex-Google | music, color theory, Australian democracy, situated software & generative art
Workspace
Fork
Public
By
Max Bo
Edited
May 17, 2024
1
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
workbook
=
FileAttachment
(
"NSW_Trainlink_Station_Data.xlsx"
)
.
xlsx
(
)
// I slightly modified the one I downloaded from Edwin's page
Insert cell
sheet0
=
workbook
.
sheet
(
0
,
{
headers
:
true
,
range
:
"A1:Q95"
}
)
Insert cell
sheet0
Filter
Columns
Sort
Slice
Save
Type Table, then Shift-Enter. Ctrl-space for more options.
Insert cell
tidy
=
sheet0
.
flatMap
(
(
row
)
=>
[
2019
,
2020
,
2021
,
2022
,
2023
]
.
map
(
(
year
)
=>
(
{
year
:
year
.
toString
(
)
,
entries
:
row
[
year
+
" Entries"
]
,
exits
:
row
[
year
+
" Exits"
]
,
total
:
row
[
year
+
" Total"
]
,
...
row
}
)
)
)
Insert cell
Insert cell
One platform
to build and deploy the best data apps
Experiment and prototype by building visualizations in live JavaScript notebooks. Collaborate with your team and decide which concepts to build out.
Use Observable Framework to build data apps locally. Use data loaders to build in any language or library, including Python, SQL, and R.
Seamlessly deploy to Observable. Test before you ship, use automatic deploy-on-commit, and ensure your projects are always up-to-date.
Try it for free
Learn more
Fork
View
Export
Edit
Add comment
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
Edit
Add comment
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
Edit
Add comment
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
Edit
Add comment
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
workbook
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
sheet0
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
Add comment
Select
Duplicate
Copy link
Embed
Delete
Cells
sheet0
File attachments
Databases
Filter
Column
Operator
Columns
Sort
Column
Direction
Descending
Ascending
Slice
From
Start
To
End
tidy
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
DOMAIN
Edit
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML