Skip to content

Instantly share code, notes, and snippets.

View plant99's full-sized avatar
🦆
everything is absurd, but plants

Shivashis Padhi plant99

🦆
everything is absurd, but plants
101 followers · 47 following
View GitHub Profile
@plant99
plant99 / one.png
Created June 25, 2020 06:02
s
@plant99
plant99 / two.geojson
Last active May 13, 2020 10:18
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@plant99
plant99 / one.geojson
Created May 13, 2020 09:43
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@plant99
plant99 / pycon2020proposal.ipynb
Created April 29, 2020 11:26
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@plant99
plant99 / pycon-proposal-tiny-exercise.md
Last active August 16, 2020 19:17

The easiest way to get an ImportError in Python is to install Python and open a console, type the following.

from sys import ham
---------------------------------------------------------------------------
@plant99
plant99 / New_Query_2020_04_01.csv
Created April 1, 2020 05:31
We can't make this file beautiful and searchable because it's too large.
hex_id,total_session_count
880982141dfffff,1
882f5aa887fffff,1
8810ad7559fffff,11
8830e02eddfffff,13
8812d03351fffff,2
88194e6a65fffff,1
88101608adfffff,1
8819599113fffff,1
8810ad7559fffff,9
@plant99
plant99 / New_Query_2020_03_31 (3).csv
Last active April 1, 2020 04:23
We can't make this file beautiful and searchable because it's too large.
_etl_created_at,_etl_updated_at,aggregate_timestamp,hex_id,order_count,sum_cost,mean_cost,min_value_cost,max_value_cost,percentile_25th_cost,percentile_50th_cost,percentile_75th_cost,percentile_99th_cost,standard_deviation_cost
2020-03-12 12:22:1584015765,2020-03-12 12:22:1584015765,2020-03-10 00:00:1583798400,883ca96501fffff,1,311.0,311.0,311.0,311.0,311.0,311.0,311.0,311.0,0.0
2020-03-12 12:22:1584015765,2020-03-12 12:22:1584015765,2020-03-10 00:00:1583798400,883ca96503fffff,1,1806.0,1806.0,1806.0,1806.0,1806.0,1806.0,1806.0,1806.0,0.0
2020-03-12 12:22:1584015765,2020-03-12 12:22:1584015765,2020-03-10 00:00:1583798400,883ca96507fffff,1,2851.0,2851.0,2851.0,2851.0,2851.0,2851.0,2851.0,2851.0,0.0
2020-03-12 12:22:1584015765,2020-03-12 12:22:1584015765,2020-03-10 00:00:1583798400,883ca96513fffff,1,655.0,655.0,655.0,655.0,655.0,655.0,655.0,655.0,0.0
2020-03-12 12:22:1584015765,2020-03-12 12:22:1584015765,2020-03-10 00:00:1583798400,883ca96515fffff,1,755.0,755.0,755.0,755.0,755.0,755.0,755.0,755.0,0.0
2020-03-12
@plant99
plant99 / db.py
Created February 28, 2020 02:53
from sqlalchemy import create_engine
engine = create_engine('sqlite:///:memory:', echo=True)
# engine = create_engine("mysql://scott:tiger@hostname/dbname", encoding='latin1', echo=True)
# engine = create_engine("postgresql://scott:tiger@localhost/test")
from sqlalchemy.ext.declarative import declarative_base
Base = declarative_base()
from sqlalchemy import Column, Integer, String
class User(Base):
__tablename__ = 'users'
@plant99
plant99 / gist:7cd8525d354558b69fbb8259e0485481
Created January 24, 2020 12:42
merge_poly.ipynb
{
"cells": [
{
"cell_type": "code",
"execution_count": 158,
"metadata": {},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
@plant99
plant99 / cartovl.html
Created January 14, 2020 05:25
<!DOCTYPE html>
<html>
<head>
<title>Add GeoJSON layer | CARTO</title>
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta charset="UTF-8">
<meta name="robots" content="noindex">
<script src="https://libs.cartocdn.com/carto-vl/v1.4.4/carto-vl.min.js"></script>
<script src="https://api.tiles.mapbox.com/mapbox-gl-js/v1.0.0/mapbox-gl.js"></script>