Skip to content

Instantly share code, notes, and snippets.

@ultrakain
ultrakain / sample.csv
Created March 31, 2017 14:17
sample csv file
id 도도부현 인구(명) 면적(km2)
1 도툐도 120202 2012.02
2 가나가와현 90000 2416.02
3 치바현 620000 5081.02
4 사이타마현 720000 3767.02
@ultrakain
ultrakain / fish_slice.py
Created March 31, 2017 12:32
python string example
fish = "<(((====<<<"
print(fish[0:4])
print(fish[4:8])
print(fish[8:])
@ultrakain
ultrakain / interation.py
Created March 31, 2017 11:49
python iteration
# string
x = "Beautiful is better than ugly"
for c in x:
print(c)
# list
l = [1, 2, 3, 4, 5, 6, 7]
for item in l:
print(item)
@ultrakain
ultrakain / multiply_example.py
Created March 31, 2017 11:46
python multiply
x_range = range(2, 10)
y_range = range(1, 10)
for x in x_range:
for y in y_range:
print('%d X %d = %d' % (x, y, x * y))
print('*' * 20)
@ultrakain
ultrakain / Python3.sublime-build
Created March 31, 2017 09:11
Sublime Python3 build setting
{
"cmd": ["/usr/local/bin/python3", "$file"],
"selector": "source.python",
"file_regex": "file \"(...*?)\", line ([0-9]+)",
"env":{"LANG": "en_US.UTF-8"}
}
@ultrakain
ultrakain / score.py
Last active April 1, 2017 02:13
python if example
score = input('Input score : ')
score_num = int(score)
if score_num >= 90:
print('A')
elif score_num >= 80 and score_num < 90:
print('B')
elif score_num >= 70 and score_num < 80:
print('C')
elif score_num >= 60 and score_num < 70:
@ultrakain
ultrakain / csv-read-write.py
Created March 3, 2017 02:06
python csv read write
# -*- coding:utf8 -*-
import csv
# read
with open('eggs.csv', 'rb') as csvfile:
spamreader = csv.reader(csvfile, delimiter=',', quotechar='|')
for row in spamreader:
print ', '.join(row)
# append
@ultrakain
ultrakain / member.csv
Last active March 3, 2017 01:55
sample csv file
We can make this file beautiful and searchable if this error is corrected: Illegal quoting in line 1.
소닉 010-1111-2222 "개발자" "팀, 여행"
비랑 010-2222-3333 "아키텍쳐" "팀, 리테일"
DG 010-3333-4444 "개발자" "팀, 정산"
우니 010-4444-5555 "개발자" "팀, 리테일"
올라 010-5555-6666 "개발자" "팀, 리테일"
@ultrakain
ultrakain / excel-write.py
Last active March 31, 2017 13:27
write excel with openpyxl
from openpyxl import Workbook
from openpyxl.styles import Font, PatternFill
wb = Workbook()
dest_filename = 'empty_book.xlsx'
ws1 = wb.active
ws1.title = u"샘플"
ws1['A1'] = '과일종류'
@ultrakain
ultrakain / leopold-need-login.py
Last active March 2, 2017 15:26
query to leopold site
# -*- coding:utf-8 -*-
import requests
from bs4 import BeautifulSoup
def leopold_login(id, password):
# 로그인 정보를 담을 수 있는 객체
s = requests.Session()
""" 로그인을 처리하는 페이지 URL """