SQL EMP 예제로 배우는 데이터 처리 방법 6-10 (SQL, Pandas, R Prog, Dplyr, SQLDF, PANDASQL, DATA.TABLE)

SQL EMP 예제로 배우는 데이터 처리 방법 6-10 (SQL, Pandas, R Prog, Dplyr, SQLDF, PANDASQL, DATA.TABLE) 

SQL 오라클 emp 예제를 대상으로 파이썬 Pandas, R 프로그래밍, R Dplyr, R Sqldf, Python Pandasql, R Data.table 에 대한 사용 방법을 정리해보고 있습니다. 

아래 예제는 변수 생성과 조건문(where), Null 처리 방법에 대한 방법을 기술하고 있습니다. 

---

6. Display employee name and annual salary for all employees. 

   : select empno, empname, 12*sal+nvl(comm,0) annualsal from emp; 

---

7. Display the names of all employees who are working in department number 10. 

   : select ename from emp where deptno=10; 

---

8. Display the names of all employees working as clerks and drawing a salary more than 3000. 

   : select ename from emp where job= 'CLERK' and sal>1000; 

---

9. Display employee number and names for employees who earn commission. 

   : select empno, ename from emp where comm is not null and comm>0; 

---

10. Display names of employees who do not earn any commission. 

   : Select empno, ename from emp where comm is null or comm=0; 


* 출처 : statwith.com/sql-emp-예제로-배우는-데이터-처리-방법-6-10-sql-pandas-r-prog-dplyr-sqldf-pandasql-data-table

SQL EMP 예제로 배우는 데이터 처리 방법 6-10 (SQL, Pandas, R Prog, Dplyr, SQLDF, PANDASQL, DATA.TABLE) » 기서무

* 자기주도온라인무료학습센터 : withmooc.com/courses/