// Load a file locally
viewof text = html`<input type=file * ">`
tweetsDF = Object.values(JSON.parse(tweetsStrings))
{
return z.unique(z.getCol("location", tweetsDF))
}
// Variation of Boston: Boston, MA; Boston; boston, etc.
newTweets = {
let newLocations = []
let locations = z.getCol("location", tweetsDF)
for (let id in locations) {
if (locations[id].toLowerCase().includes('boston')){
newLocations.push('Boston, MA')
} else {
newLocations.push(locations[id])
}
}
return z.addCol("cleanLocations", newLocations, tweetsDF)
}
locationCount={
let count= z.filter(r => r.group!= "", z.gbCount("group", z.groupBy(d => d.cleanLocations, newTweets)))
return z.sortByCol('count', 'des', count)
}
vegalite({
data: {values:locationCount.slice(0,25)},
mark: "bar",
encoding: {
x: {field: "group", type: "nominal",sort:{encoding:"y"},axis: {title: "Locations"}},
y: {field: "count", type: "quantitative", axis: {title: "count"}},
color:{field: "group", "type": "nominal"}
}
})
geolocated={
return z.filter(r => r.lon!= null, z.filter(r => r.lat!= null, tweetsDF))
}
vegalite({
data: {values: geolocated},
mark: "point",
encoding: {
x: {field: "lon", type: "quantitative",scale: {domain: [-71.5,-70.5]},axis: {title: "longitude"}},
y: {field: "lat", type: "quantitative",scale: {domain: [42,43]}, axis: {title: "latitude"}}
}
})
// Load a file locally, search tweets with the word "happy"
viewof hashtag_text = html`<input type=file * ">`
tweetsStringsHash= Files.text(hashtag_text)
tweetsHasgDF = Object.values(JSON.parse(tweetsStringsHash))
locationHashCount={
let count= z.filter(r => r.group!= "", z.gbCount("group", z.groupBy(d => d.location, tweetsHasgDF)))
return z.sortByCol('count', 'des', count)
}
cleanHashTweets = {
let newLocations = []
let locations = z.getCol("location", tweetsHasgDF)
for (let id in locations) {
if (locations[id].toLowerCase().includes('united states')){
newLocations.push('United States')
} else if (locations[id].toLowerCase().includes('usa')) {
newLocations.push('United States')
} else{
newLocations.push(locations[id])
}
}
return z.addCol("cleanLocations", newLocations, tweetsHasgDF)
}
z.unique(z.getCol("hashtag",cleanHashTweets ))
cleaned =
{
let notNull=z.filter(r => r.lat != null, cleanHashTweets)
let hashCount=[]
for (var i=0; i<notNull.length; i++){
var Count=notNull[i]["hashtag"].length
hashCount.push(Count)
}
return z.addCol("hashtagCount", hashCount, notNull)
}
vegalite({
data: {values: cleaned},
mark: "point",
encoding: {
x: {field: "lon", type: "quantitative"},
y: {field: "lat", type: "quantitative"},
color:{field: "hashtagCount", type: "nominal",title:"Number of hashtags"}
}
})
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.
