onewesong

#

onewesong

MySQL Cheat Sheet

Help with SQL commands to interact with a MySQL database

MySQL Locations

• Mac /usr/local/mysql/bin
• Windows /Program Files/MySQL/MySQL version/bin
• Xampp /xampp/mysql/bin

Add mysql to your PATH

onewesong

pandas 常用

• 直接拷贝表格传入notebook

pd.read_clipboard()

• 读取xls文件转成csv文件

pd.ExcelFile(xls_fpath).parse().to_csv(csv_fpath)

onewesong

from datetime import datetime
import aiohttp
import asyncio

URL = "https://medium.fabianbosler.de/run"


async def sample_asyncio(samples):
    start = datetime.now()

onewesong

#!/usr/bin/env python

"""
 Use Selenium to Measure Web Timing

 Performance Timing Events flow

 navigationStart -> redirectStart -> redirectEnd -> fetchStart -> domainLookupStart -> domainLookupEnd 
  -> connectStart -> connectEnd -> requestStart -> responseStart -> responseEnd 
  -> domLoading -> domInteractive -> domContentLoaded -> domComplete -> loadEventStart -> loadEventEnd

onewesong

#!/usr/bin/env python3
# coding: utf-8
import cson


def read_file(fp):
    with open(fp) as f:
        return f.read()