Pandas 값을 컬럼으로 변환

1 개요

Pandas 값을 컬럼으로 변환

import pandas as pd
import io
tsv = """
timestamp	user_id	action_type	session_id
2021-03-02 11:11:00	1	login	1001
2021-03-02 11:11:09	1	logout	1001
2021-03-02 11:11:17	1	login	1002
2021-03-02 11:11:35	1	logout	1002
2021-03-02 11:11:00	2	login	2001
2021-03-02 11:11:26	2	logout	2001
2021-03-02 11:11:00	3	login	3001
2021-03-02 11:11:09	3	logout	3001
2021-03-02 11:11:17	3	login	3002
2021-03-02 11:11:35	3	logout	3002
"""
df = pd.read_csv(io.StringIO(tsv),sep='\t')
df.timestamp = pd.to_datetime(df.timestamp, format='%Y-%m-%d %H:%M:%S')
df

pd.pivot_table(df, index='session_id', values='timestamp', columns=['action_type'], aggfunc='first')

2 같이 보기

• Pandas pivot_table()
• Pandas 그룹별 기간 구하기