Python

작성일자 : 2023-11-05 Ver 0.1.1 0. Tabpy https://github.com/tableau Tableau On a mission to help people see and understand data. http://tableau.com - Tableau github.com 1. Tabpy 설치 1) Anaconda에 가상환경 생성 conda create --name tabpy-env python=3.8. 2) tabpy 설치 pip install tabpy 3) tabpy 실행 tabpy http://localhost:9004/를 통해 tabpy 실행 확인 2. Tableau Desktop에서 tabpy 연결 1) 상단 '도움말' 탭 -> '설정 및 성능' -> '분석 확장 프로그램..

작성일자 : 2023-10-31 Ver 0.1.1 33 ~ 100 문제 풀이 : https://youtu.be/00rctVVSSoA?si=Du3KDMiQeHq7Gp-F 7. Merge, Concat¶국가별 5세이하 사망비율 통계 : https://www.kaggle.com/utkarshxy/who-worldhealth-statistics-2020-complete 데이터 변형 Dataurl = https://raw.githubusercontent.com/Datamanim/pandas/main/mergeTEst.csv Q91. df1과 df2 데이터를 하나의 데이터 프레임으로 합쳐라 In [1]: import pandas as pd In [15]: df = pd.read_csv('https://raw.git..

작성일자 : 2023-10-31 Ver 0.1.1 33 ~ 100 문제 풀이 : https://youtu.be/00rctVVSSoA?si=Du3KDMiQeHq7Gp-F 6. Pivot¶국가별 5세이하 사망비율 통계 : https://www.kaggle.com/utkarshxy/who-worldhealth-statistics-2020-complete Dataurl = 'https://raw.githubusercontent.com/Datamanim/pandas/main/under5MortalityRate.csv' In [1]: import pandas as pd In [26]: df9 = pd.read_csv('https://raw.githubusercontent.com/Datamanim/pandas/mai..

작성일자 : 2023-10-30 Ver 0.1.1 33 ~ 100 문제 풀이 : https://youtu.be/00rctVVSSoA?si=Du3KDMiQeHq7Gp-F 5. Time Series¶주가 데이터 : https://raw.githubusercontent.com/guipsamora/pandas_exercises/master/06_Stats/Wind_Stats/wind.data DataUrl = 'https://raw.githubusercontent.com/Datamanim/pandas/main/timeTest.csv' In [1]: import pandas as pd In [53]: df7 = pd.read_csv('https://raw.githubusercontent.com/Datamanim/..