Published
Edited
Apr 3, 2019
// Load a file locally
viewof text = html`<input type=file * ">`
// your code here
tweetsStrings = Files.text(text)
tweetsDF = Object.values(JSON.parse(tweetsStrings))
count = {
let countArray = []
let groupedLocations = z.groupBy(x => x.cleanLocations, newTweets)
for (const key of Object.keys(groupedLocations)) {
countArray.push({location: key, count: groupedLocations[key].length})
}
return countArray
}
countSorted = z.sortByCol('count', 'des', count)
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 if (locations[id].toLowerCase().includes('waltham')){
newLocations.push('Waltham, MA')
} else if (locations[id].toLowerCase().includes('cambridge')){
newLocations.push('Cambridge, MA')
} else if (locations[id]==""){
newLocations.push('NULL')
} else {
newLocations.push(locations[id])
}
}
return z.addCol("cleanLocations", newLocations, tweetsDF)
}
newTweets
vegalite({
data: {values: countSorted.slice(0,15)},
mark: "bar",
encoding: {
x: {field: "location", type: "nominal", sort:'*'},
y: {field: "count", type: "quantitative"},
color: {"field": "location", "type": "nominal"}
}
})
// your code here
notNull = z.filter(r => r.lat != null, tweetsDF)
vegalite({
data: {values: notNull},
mark: "circle",
encoding: {
x: {field: "lon", type: "quantitative",scale: {domain:[-71.3,-70.8]}},
y: {field: "lat", type: "quantitative",scale: {domain:[42.3,42.5]}}
}
})
vegalite({
data: {values: notNull},
projection: {type:"albersUsa"},
mark: "circle",
encoding: {
longitude: {field: "lon", type: "quantitative"},
latitude: {field: "lat", type: "quantitative"}
},
size:{value:10},
config:{view:{stroke:"transparent"}}
})
// Load a file locally
viewof hashtag_text = html`<input type=file * ">`
// your ciode here
tweetsStrings2 = Files.text(hashtag_text)
tweetsDF_temp = Object.values(JSON.parse(tweetsStrings2))
tweetsDF2 = {
let obj = []
for (let i in tweetsDF_temp){
obj.push(tweetsDF_temp[i][1])}
return obj
}
count_unclean = {
let countArray = []
let groupedLocations = z.groupBy(x => x.location, tweetsDF2)
for (const key of Object.keys(groupedLocations)) {
countArray.push({location: key, count: groupedLocations[key].length})
}
return countArray
}
countSorted_unclean = z.sortByCol('count', 'des', count_unclean)
newTweets2 = {
let newLocations = []
let locations = z.getCol("location", tweetsDF2)
for (let id in locations) {
if (locations[id].toLowerCase().includes('caracas')){
newLocations.push('Caracas, Venezuela')
} else if (locations[id].toLowerCase()=='venezuela'){
newLocations.push('Venezuela')
}else if (locations[id].toLowerCase().includes('miami')){
newLocations.push('Miami, FL')
} else if (locations[id].toLowerCase().includes('bogotá')){
newLocations.push('Bogotá, Colombia')
} else if (locations[id].toLowerCase().includes('bogota')){
newLocations.push('Bogotá, Colombia')
} else if (locations[id].toLowerCase()=='florida'){
newLocations.push('Florida, USA')
} else if (locations[id].toLowerCase()=='usa'){
newLocations.push('United States')
} else if (locations[id]==""){
newLocations.push('NULL')
} else {
newLocations.push(locations[id])
}
}
return z.addCol("cleanLocations", newLocations, tweetsDF2)
}
count2 = {
let countArray = []
let groupedLocations = z.groupBy(x => x.cleanLocations, newTweets2)
for (const key of Object.keys(groupedLocations)) {
countArray.push({location: key, count: groupedLocations[key].length})
}
return countArray
}
countSorted2 = z.sortByCol('count', 'des', count2)
// your code here
notNull2 = z.filter(r => r.lat != null, tweetsDF2)
{
for (let i in notNull2){
notNull2[i]["num_hash"]=notNull2[i].hashtags.length}
return notNull2
}
vegalite({
data: {values: notNull2},
mark: "circle",
encoding: {
x: {field: "lon", type: "quantitative"},
y: {field: "lat", type: "quantitative"},
color: {field: "num_hash", 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.
