[데이터 출력] 데이터세트(테이블) 출력 - 1

 

1. Display the dept information from department table.

 

* dept 테이블을 출력하시오.

---

• 파이썬 & R 패키지 호출 및 예제 데이터 생성 링크

• 데이터세트(테이블) 출력

Oracle : select 구문 파이썬 Pandas : 데이터프레임 출력 R 프로그래밍 : 데이터프레임 출력 R Dplyr Package : print() R sqldf Package : select 구문 Python pandasql Package : select 구문 R data.table Package : Data.table 변환 및 출력 SAS Proc SQL : Select 구문 SAS Data Step : Proc Print Python Dfply Package : display 구문 파이썬 Base 프로그래밍 :

 

---

1. 오라클(Oracle)

Oracle Programming

select * 
from   dept;

 

---

2. 파이썬(Pandas)

Python Programming

dept

 

Results

	deptno	dname	loc
0	10	ACCOUNTING	NEW YORK
1	20	RESEARCH	DALLAS
2	30	SALES	CHICAGO
3	40	OPERATIONS	BOSTON

 

---

3. R Programming (R Package)

 

Python Programming

%%R

dept

 

Results

# A tibble: 4 x 3
  deptno dname      loc     
   <dbl> <chr>      <chr>   
1     10 ACCOUNTING NEW YORK
2     20 RESEARCH   DALLAS  
3     30 SALES      CHICAGO 
4     40 OPERATIONS BOSTON  

 

---

4. R Dplyr Package

 

Python Programming

%%R

dept %>% print()

 

Results

# A tibble: 4 x 3
  deptno dname      loc     
   <dbl> <chr>      <chr>   
1     10 ACCOUNTING NEW YORK
2     20 RESEARCH   DALLAS  
3     30 SALES      CHICAGO 
4     40 OPERATIONS BOSTON  

 

---

5. R sqldf Package

 

Python Programming

%%R

require(sqldf)
sqldf("select * from dept;")

 

Results

  deptno      dname      loc
1     10 ACCOUNTING NEW YORK
2     20   RESEARCH   DALLAS
3     30      SALES  CHICAGO
4     40 OPERATIONS   BOSTON

 

---

6. Python pandasql Package

 

Python Programming

import pandasql as ps

ps.sqldf("select * from dept;")

 

Results

	deptno	dname	loc
0	10	ACCOUNTING	NEW YORK
1	20	RESEARCH	DALLAS
2	30	SALES	CHICAGO
3	40	OPERATIONS	BOSTON

 

---

7. R data.table Package

• Data.table의 Key는 설정 안 함. (속도 개선을 위하여 Key 설정 필요)

R Programming

%%R

DT          <- data.table(emp)
dept_DT     <- data.table(dept)

dept_DT

 

Results

   deptno      dname      loc
1:     10 ACCOUNTING NEW YORK
2:     20   RESEARCH   DALLAS
3:     30      SALES  CHICAGO
4:     40 OPERATIONS   BOSTON

 

---

8. SAS Proc SQL

 

SAS Programming

%%SAS sas

proc sql;
  select *
  from   dept;
quit;

 

Results

OBS	deptno	dname	loc
1	10	ACCOUNTING	NEW YORK
2	20	RESEARCH	DALLAS
3	30	SALES	CHICAGO
4	40	OPERATIONS	BOSTON

 

---

9. SAS Data Step

 

SAS Programming

%%SAS sas

proc print data=dept;
run;

 

Results

OBS	deptno	dname	loc
1	10	ACCOUNTING	NEW YORK
2	20	RESEARCH	DALLAS
3	30	SALES	CHICAGO
4	40	OPERATIONS	BOSTON

 

---

10. Python Dfply Package

 

Python Programming

display(dept >> head(5))

 

Results

	deptno	dname	loc
0	10	ACCOUNTING	NEW YORK
1	20	RESEARCH	DALLAS
2	30	SALES	CHICAGO
3	40	OPERATIONS	BOSTON

 

---

 

[SQL, Pandas, R Prog, Dplyr, SQLDF, PANDASQL, DATA.TABLE]   SQL EMP 예제로 만나는 테이블 데이터 처리 방법 리스트