Skip to content

Instantly share code, notes, and snippets.

View ArtemD's full-sized avatar
💭
I may be slow to respond.

Artem Daniliants ArtemD

💭
I may be slow to respond.
View GitHub Profile
import streamlit as st
import pandas as pd
import numpy as np
st.title('Uber pickups in NYC')
DATE_COLUMN = 'date/time'
DATA_URL = ('https://s3-us-west-2.amazonaws.com/'
'streamlit-demo-data/uber-raw-data-sep14.csv.gz')
from csv2db import *
with open('data.csv', encoding='utf-8') as csv_file:
csv_reader = csv.reader(csv_file, delimiter=';')
line_count = 0
for row in csv_reader:
if line_count!=0:
result = insert2db(name=row[0], address=row[1], postcode=row[2], city=row[3], date=row[4], type=row[5], businessid=row[6])
import csv
import os
from pprint import pprint as pp
from sqlalchemy import create_engine, text
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy import Column, String, Integer, DateTime
from sqlalchemy.orm import sessionmaker
from datetime import datetime
from sqlalchemy import or_
import csv
import os
from pprint import pprint as pp
from sqlalchemy import create_engine, text
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy import Column, String, Integer, DateTime
from sqlalchemy.orm import sessionmaker
from datetime import datetime
wordpress:
image: wordpress
links:
- mariadb:mysql
environment:
- WORDPRESS_DB_PASSWORD=password
ports:
- "80:80"
volumes:
- ./html:/var/www/html
@ArtemD
ArtemD / .taskrc
Last active May 12, 2017 13:11
My .taskrc (TaskWarrior) configuration file
# Files
data.location=/mnt/t/Dropbox/Text/TODO.txt
# Color theme (uncomment one to use)
#include /usr/share/task/light-16.theme
#include /usr/share/task/light-256.theme
#include /usr/share/task/dark-16.theme
#include /usr/share/task/dark-256.theme
#include /usr/share/task/dark-red-256.theme
#include /usr/share/task/dark-green-256.theme
@ArtemD
ArtemD / Dockerfile
Created July 12, 2014 07:28
Dockerfile for Nginx 1.7.3 + Pagespeed 1.8.31.4-beta
FROM ubuntu:14.04
MAINTAINER Artem Daniliants <artem.daniliants_at_lumolink.com>
# update ubuntu
RUN apt-get -qq update
# upgrade (security updates etc)
# RUN apt-get -qq upgrade --yes
RUN apt-get install --yes build-essential zlib1g-dev libpcre3-dev libpcre3 libssl-dev libxslt1-dev libxml2-dev libgd2-xpm-dev libgeoip-dev libgoogle-perftools-dev libperl-dev unzip wget
# BEGIN W3TC Browser Cache
<IfModule mod_deflate.c>
<IfModule mod_headers.c>
Header append Vary User-Agent env=!dont-vary
</IfModule>
AddOutputFilterByType DEFLATE text/css text/x-component application/x-javascript application/javascript text/javascript text/x-js text/html text/richtext image/svg+xml text/plain text/xsd text/xsl text/xml image/x-icon application/json
<IfModule mod_mime.c>
# DEFLATE by extension
AddOutputFilter DEFLATE js css htm html xml
</IfModule>