Skip to content

Instantly share code, notes, and snippets.

View weizh888's full-sized avatar

weizh888

10 followers · 28 following
  • 08:52 (UTC +08:00)
View GitHub Profile
@weizh888
weizh888 / data.geojson
Created June 27, 2022 15:43
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@weizh888
weizh888 / mysql_db_migration.md
Last active September 24, 2019 04:03
copy tables or databases from one MySQL server to another MySQL server

Do in ONE Step

mysqldump -u root -p database_name | mysql -h other-host.com database_name

Do in TWO Steps

Step 1: dump from old DB

mysqldump -u root -p database_name table_name > dump.txt
@weizh888
weizh888 / gist:d82d54f6813a6637b67575669565e1e4
Created July 26, 2019 09:31 — forked from CristinaSolana/gist:1885435
Keeping a fork up to date

1. Clone your fork:

git clone [email protected]:YOUR-USERNAME/YOUR-FORKED-REPO.git

2. Add remote from original repository in your forked repository:

cd into/cloned/fork-repo
git remote add upstream git://github.com/ORIGINAL-DEV-USERNAME/REPO-YOU-FORKED-FROM.git
git fetch upstream
@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

@weizh888
weizh888 / virtualenv.md
Created November 22, 2018 10:43
  • Specify the python version
virtualenv --python=<local_python_path> <venv_name>
@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 / 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 / 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 / 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 / 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))