Skip to content

Instantly share code, notes, and snippets.

View weizh888's full-sized avatar

weizh888

10 followers · 28 following
  • 13:58 (UTC +08:00)
View GitHub Profile
@weizh888
weizh888 / example.py
Created June 28, 2018 16:37 — forked from tkaemming/example.py
python logging timer decorator
import logging, time
from timer import timed
logger = logging.getLogger()
logger.setLevel(logging.DEBUG)
handler = logging.StreamHandler()
handler.setLevel(logging.DEBUG)
logger.addHandler(handler)
@weizh888
weizh888 / error_unzip.md
Last active September 10, 2018 08:01
Error: end of central directory record signature not found
  • Zip file created in python using:
import zipfile

zf = zipfile.ZipFile(zip_file_path, "w", zipfile.ZIP_DEFLATED)
zf.write(file, os.path.basename(file))
  • When unzipping file, got error:
@weizh888
weizh888 / install_MySQLdb_python.md
Last active April 26, 2020 00:57

Step 1. Install MySQL

Debian / Ubuntu

sudo apt-get update
sudo apt-get install python-dev default-libmysqlclient-dev
  • Python 3

sudo apt-get install python3-dev

@weizh888
weizh888 / read_csv_from_zip.md
Created September 11, 2018 08:56 
import pandas as pd
import zipfile

zip_file_path = 'file_path'
zf = zipfile.ZipFile(zip_file_path)

csv_file_name = 'csv_file_name'
df = pd.read_csv(zf.open(csv_file_name))
@weizh888
weizh888 / get_filename_from_filepath.md
Created September 19, 2018 11:56
  • Method 1
import os

file_path = 'path/to/file/example.csv'
filename_w_ext = os.path.basename(file_path)
filename, file_ext = os.path.splitext(filename_w_ext)

Output:

@weizh888
weizh888 / SQL_time_conversion.md
Last active September 25, 2018 03:53

  • MYSQL

    • date --> unix timestamp

    UNIX_TIMESTAMP('2018-09-25', 'yyyy-MM-dd')

    • unix timestamp --> date

FROM_UNIXTIME(1255033470, 'yyyy-MM-dd')

@weizh888
weizh888 / fork_from_another_fork.md
Last active April 11, 2019 03:43 
git clone xxx

git remote add <another-fork-alias> <another-fork-URL>

git checkout <local_branch>
@weizh888
weizh888 / jupyter-notebook-helper.md
Last active November 21, 2018 08:49

Forward jupyter notebook from remote host

Host abc
  HostName xx.xx.xxx.xx
  User username
  • In .bash_profile:
function jptabc(){
@weizh888
weizh888 / virtualenv.md
Created November 22, 2018 10:43
  • Specify the python version
virtualenv --python=<local_python_path> <venv_name>
@weizh888
weizh888 / git_presettings.md
Created November 27, 2018 13:21

  • .gitignore

  • git config core.fileMode false

  • git config core.autocrlf or git config --global core.autocrlf or git config --local core.autocrlf