본문 바로가기

Programming84

[matplotlib] 텍스트 넣기 06. 텍스트 In [2]: import matplotlib.pyplot as plt import matplotlib matplotlib.rcParams['font.family'] = 'AppleGothic' matplotlib.rcParams['font.size'] = 15 #글자크기 matplotlib.rcParams['axes.unicode_minus'] = False #한글폰트 사용시 마이너스 글자 깨짐 해결 In [3]: x = [1,2,3] y = [2,4,8] In [4]: plt.plot(x,y) Out[4]: [] In [6]: plt.plot(x,y,marker='o') for idx, txt in enumerate(y): plt.text(x[idx],y[idx], txt) In [9].. 2023. 3. 27.
구글 애널리틱스 프로그램 Tableu https://www.data-to-viz.com/ https://www.youtube.com/watch?v=rkimIhnLKGI&list=PLU8ezI8GYqs74i8hy_qln3FvkAuSpE-r1&index=3 How to make a chart https://help.tableau.com/current/pro/desktop/en-us/buildexamples_highlight.htm 2023. 3. 27.
[GA] Google Analytics Certificate Program (GA Day) Course 5 Data Aggregation- SQL JOIN 사용 Select DATE, Region, Small_Bags, Large_Bags, XLarge_Bags, Total_Bags, (Small_Bags / Total_Bags)*100 as SB_percent From avocado_data.avocado_prices WHERE Total_Bags 0 or Total_Bags != 0 -- values we are calculating does not equal to 0 How to use TEMPORARY TABLE With trips_over_1_hr as ( SELECT * FROM `bigquery-public-data.new_york_citibike.citibike_trips` WHERE tripduration >=60 ) -- this is a de.. 2023. 3. 27.
[GA] Google Analytics Certificate Program (GA Day) Course 5 Data Aggregation- SQL JOIN 사용 1. Join SELECT employees.name AS employee_name, employees.role AS employee_role, departments.name AS department_name FROM onyx-smoke-380601.employee_data.employees INNER JOIN -- in the other table we are using employee_data.departments ON employees.department_id=departments.department_id SELECT employees.name AS employee_name, employees.role AS employee_role, departments.name AS department_name .. 2023. 3. 25.

티스토리툴바