[MSSQL] 세로 데이터 가로로 출력 (데이터 한줄로 출력) STUFF, FOR XML PATH

http://ggmouse.tistory.com/127

DECLARE @string AS VARCHAR(1000);

SET @string = '';

WITH TABLE_A (NAME) AS (

    SELECT '손꽁쥐' UNION ALL

    SELECT '윤선생' UNION ALL

    SELECT '황박사'

)

SELECT @string = NAME + ', ' + @string FROM TABLE_A

SELECT @string AS '가로출력' 

--  

WITH TABLE_A (CLASS, NAME) AS (

    SELECT 'A', '손꽁쥐' UNION ALL

    SELECT 'B', '윤선생' UNION ALL

    SELECT 'A', '황박사'

)

SELECT * FROM

(

    SELECT CLASS, STUFF((SELECT ',' + NAME FROM TABLE_A WHERE CLASS = A.CLASS FOR XML PATH('')), 1, 1, '') AS 'Result'

    FROM TABLE_A AS A

) A

GROUP BY A.CLASS, A.Result

Unofficial Windows Binaries for Python Extension Packages

matplotlib의 scatter 만들기 . 그래프

plot 버전 체크  

scatter 만들기

import plotly.plotly as py

import plotly.graph_objs as go

# Create random data with numpy

import numpy as np

N = 1000

random_x = np.random.randn(N)

random_y = np.random.randn(N)

# Create a trace

trace = go.Scatter(

    x = random_x,

    y = random_y,

    mode = 'markers'

)

data = [trace]

# Plot and embed in ipython notebook!

py.iplot(data, filename='basic-scatter')

# or plot with: plot_url = py.plot(data, filename='basic-line')

...

파이썬에서 유니코드 스트림 다루기

# 입력 스트림과 출력 스트림을 연다

input = open("input.txt", "rt", encoding="utf-16")  

output = open("output.txt", "wt", encoding="utf-8")

# 유니코드 데이터 조각들을 스트리밍한다

with input, output:  

    while True:

        # 데이터 조각을 읽고

        chunk = input.read(4096)

        if not chunk:

            break

        # 수직 탭을 삭제한다

        chunk = chunk.replace("\u000B", "")

        # 데이터 조각을 쓴다

        output.write(chunk)

응용: 쉘 스크립트를 이용해 해당 디렉토리의 파일들 모두 변경 

- char-convert.sh

#!/bin/bash

LIST=`ls -A1 | grep ".csv"`

for file in $LIST

do

  python ./char-convert.py $file

done

- char-convert.py

#!/usr/bin/python

#-*- coding: utf-8 -*-

import codecs

import sys

file = sys.argv[1]

file2 = file.split('.csv')[0]+"-2.csv"

infile = codecs.open(file, 'r', encoding='utf-8')

outfile = codecs.open(file2, 'w', encoding='euc_kr')

for line in infile:

  line = line.replace(u'\xa0', ' ')  

  outfile.write(line)

infile.close()

outfile.close()

...

Mockup tool 

https://balsamiq.com/products/mockups/

To find out more about Balsamiq Mockups 3, head to the product page at http://balsamiq.com/products/mockups/

Download a free trial here: http://balsamiq.com/download/