vingkan / README.md

Created August 23, 2024 19:18

Split and combine a SQLite database file into smaller parts to stay under GitHub size limits.

Combine and Split a SQLite Database File

The first time you use this script, you will have to give it permissions:

chmod 0777 split_database.sh
chmod 0777 combine_database.sh

Then you can run the scripts like this:

vingkan / starter.html

Created June 8, 2022 07:58

Example starter code to try out frontend development on CoderPad (React, Vue, or HTML/CSS/JS).

	<html>
	<head>
	<meta charset="UTF-8">
	<title>App</title>
	<script src="https://unpkg.com/[email protected]/umd/react.production.min.js"></script>
	<script src="https://unpkg.com/[email protected]/umd/react-dom.production.min.js"></script>
	<script src="https://cdn.jsdelivr.net/npm/vue@2/dist/vue.js"></script>
	<script src="https://unpkg.com/@babel/[email protected]/babel.min.js"></script>
	<style>

vingkan / example_discord_cat_bot.py

Last active January 9, 2022 01:19

Example Discord bot to send you cat pictures.

	import discord
	import os
	import requests

	from discord.ext import commands


	DISCORD_BOT_TOKEN = os.environ["DISCORD_BOT_TOKEN"]
	RANDOM_CAT_URL = "https://cataas.com"

vingkan / README.md

Last active June 12, 2019 04:41

Spectral Clustering Demo

Run the Jupyter notebook in your browser with Binder:

vingkan / assessor_solutions.sql

Created May 1, 2019 01:29

Solution queries for two truths and a lie with the Cook County Assessor's modeling data.

	-- The only properties with 10 or more full bathrooms are apartments.

	SELECT class
	WHERE fbath >= 10

	-- On average, properties designed from an architect's plan sold for twice as much as properties designed from a stock plan.

	SELECT tp_plan, AVG(sale_price)
	WHERE tp_plan IN (1, 2)
	GROUP BY tp_plan

vingkan / rideshare_solutions.sql

Last active February 24, 2021 03:03

Solution queries for two truths and a lie with the rideshare dataset.

	-- Most rides start and end in the Near North Side community area.

	SELECT
	pickup_community_area,
	COUNT(*) as trips
	GROUP BY pickup_community_area
	ORDER BY trips DESC

	-- On average, riders picked up in the Lincoln Square community area tip better than riders picked up in the Loop.

vingkan / fields.md

Created April 7, 2019 19:54

Night at Lyft - Trip Field Names

Each trip has the following fields. See the descriptions below.

vingkan / hawklinkscraper.js

Created March 27, 2019 21:22

Roster scraper for HawkLink (2019).

	/*
	* 1. Go to https://iit.campuslabs.com/engage/organization/acm/roster
	* 2. Open the browser console
	* 3. Copy and paste this script into the console and run
	* 4. Keep tab open and do not click anywhere until the script completes
	* 5. Save the page output as a .csv
	*/

	var showing = document.querySelector('#roster-members').parentElement.children[1].children[0].innerText.split(' ');
	var total = parseInt(showing[3]);

vingkan / hawklinkscraper.js

Created March 27, 2019 21:22

Roster scraper for HawkLink (2019).

	/*
	* 1. Go to https://iit.campuslabs.com/engage/organization/acm/roster
	* 2. Open the browser console
	* 3. Copy and paste this script into the console and run
	* 4. Keep tab open and do not click anywhere until the script completes
	* 5. Save the page output as a .csv
	*/

	var showing = document.querySelector('#roster-members').parentElement.children[1].children[0].innerText.split(' ');
	var total = parseInt(showing[3]);

vingkan / solution.sql

Created March 6, 2019 03:50

Solution to 20 questions with the traffic crash dataset.

	SELECT RD_NO
	WHERE weather_condition = "RAIN"
	AND crash_type = "INJURY AND / OR TOW DUE TO CRASH"
	AND (INJURIES_FATAL = 0 or injuries_fatal is null)
	AND crash_hour IN (13,14,15)
	AND DAMAGE = "OVER $1,500"
	and first_CRASH_type not in ('REAR END','TURNING'
	,'ANGLE', 'PARKED MOTOR VEHICLE', 'HEAD ON'
	, 'FIXED OBJECT', "SIDESWIPE SAME DIRECTION")
	AND STREET_DIRECTION in ("E","W")

Vinesh Kannan vingkan