Skip to content

Instantly share code, notes, and snippets.

group: cs143hw2
description[[ the data for this dataset was generated using {'<'}http://www.generatedata.com/>
* the relation _flights_ contains basic information about Southwest flights.
* the relation _aircraft_ contains information about Southwest aircraft, including those acquired from Airtran.
* the relation _airtran_aircraft_ contains information about aircraft that Southwest acquired from Airtran.
]]
flights = {
from to flightnum departure tail
LAX SFO 181 8 N8751R
# UCLA COMPUTER SCIENCE 143
# Spring 2022, Prof. Rosario
#
# Docker services for Postgres, MongoDB, Redis, Neo4j
# And a few other DBs you may want to try: CockroachDB, MariaDB, Memcached
#
# Goes well with these docker-compose networking/ingress container examples:
# https://gist.github.com/pirate/1996d3ed6c5872b1b7afded250772f7c
version: '2.4'
services:
group: ucla examples
description[[ the data for this dataset was generated using {'<'}http://www.generatedata.com/>
* the relation _Video_ contains basic information about YouTube videos.
* the relation _Comment_ contains the basic information of a YouTube comment. A video can have multiple comments.
]]
youtube_video = {
video_id title channel cat_id views likes dislikes
XpVt6Z1Gjjo "1 YEAR OF VLOGGING" "Logan Paul Vlogs" 24 4394029 320053 5931
game winner turn type
1 2 19 LINE
1 10 46 BOARD
2 5 16 LINE
2 3 49 BOARD
3 8 14 LINE
3 5 43 BOARD
4 8 27 LINE
4 9 42 BOARD
5 10 20 LINE
@RyanRosario
RyanRosario / p2b_plots.py
Last active June 8, 2018 05:47
Plots for CS 143 Project 2B, Python
#!/usr/bin/env python3
# May first need:
# In your VM: sudo apt-get install libgeos-dev (brew install on Mac)
# pip3 install https://github.com/matplotlib/basemap/archive/v1.1.0.tar.gz
import matplotlib
matplotlib.use("Agg")
import matplotlib.pyplot as plt
import pandas as pd
@RyanRosario
RyanRosario / p2b_plots.R
Last active June 8, 2018 00:16
Plots (R) for CS 143, Project 2B Final Report
## R CODE FOR GRAPHICS FOR
## FINAL DELIVERABLE FOR CS143 PROJECT 2B
# If you already have R installed on your home machine, transfer the resulting files
# to your shared directory and do the visualizations in R on your home system rather than
# in the VM because R is not installed there.
# R is actually the simplest software for making plots.
##################################################