The avatar for @deepalikank
Deepali Kank
Data Analyst with a passion for Data visualization and storytelling
Public
Edited
Jul 27, 2024
9 stars
1
Insert cell
Insert cell
Insert cell
Insert cell
import { Plot } from "@mkfreeman/plot-tooltip"
Insert cell
Press Freedom Index@2.csv
Type Table, then Shift-Enter. Ctrl-space for more options.

Insert cell
Press Freedom Index@2.csv
SELECT * FROM "Press Freedom Index"
Insert cell
Press Freedom Index@2.csv
SELECT Year, ISO, Rank, Score, Country, Zone,
CASE
WHEN Score between 85 and 100 THEN 'Good'
WHEN Score between 70 and 85 then 'Satisfactory'
WHEN Score between 55 and 70 THEN 'Problematic'
WHEN Score between 40 and 55 THEN 'Difficult'
WHEN Score between 0 and 40 THEN 'Very Serious'
ELSE Score
END AS Score_level
FROM "Press Freedom Index"
Insert cell
df
select Year, Score,Score_level, Country, count(*) as level
from df
where Year in (2021,2022,2023)
group by Score, Score_level, Year, Country
order by Score_level desc;
Insert cell
df
select Year, Score_level, count(*) as level
from df
where Year in (2021,2022,2023)
group by Score_level, Year
order by Score_level desc;
Insert cell
df2
select Year, Score_level, count(*) as level
from df2
where Year = '2023'
group by Score_level, Year
order by Score_level desc;
Insert cell
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.
Learn more