ATAN Oracle Function [Oracle, Pandas, R Prog, Dplyr, Sqldf, Pandasql, Data.Table]

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

---

[ ATAN 함수 ]

 

---

ATAN(n) 함수는 n의 역탄젠트(arc tangent) 값을 반환한다.

인수 n은 -1 ~ 1의 범위이고, 반환값은 라디안으로 표현되는 -pi/2~pi/2의 범위값이다.

 

• 함수 설명: ATAN 오라클 함수 링크

---

1. Oracle(오라클)

Oracle Programming

SELECT ATAN(.3) "Arc_Tangent" 
FROM   DUAL;

 

Results

            Arc_Tangent
.2914567944778670919956046214328911935013

 

---

2. Python Pandas(파이썬)

Python Programming

math.atan(.3)

 

Results

0.2914567944778671

 

---

• 수치형 목록 예제

Python Programming

emp.sal.apply(lambda x: math.atan(x/10000)).head()

 

Results

0    0.079830
1    0.158655
2    0.124355
3    0.289162
4    0.124355
Name: sal, dtype: float64

 

 

---

3. R Programming (R Package)

 

R Programming

%%R

atan(.3)

 

Results

[1] 0.2914568

 

---

• 수치형 목록 예제

R Programming

%%R

atan(emp$sal / 10000)

 

Results

 [1] 0.07982999 0.15865526 0.12435499 0.28916164 0.12435499 0.27763916
 [7] 0.24026727 0.29145679 0.46364761 0.14888995 0.10955953 0.09471575
[13] 0.29145679 0.12927500

 

 

---

4. R Dplyr Package

R Programming

%%R

emp %>%
  dplyr::mutate(sal_atan = atan(sal / 10000)) %>%
  head()

 

Results

# A tibble: 6 x 9
  empno ename  job        mgr hiredate     sal  comm deptno sal_atan
                      
1  7369 SMITH  CLERK     7902 1980-12-17   800    NA     20   0.0798
2  7499 ALLEN  SALESMAN  7698 1981-02-20  1600   300     30   0.159 
3  7521 WARD   SALESMAN  7698 1981-02-22  1250   500     30   0.124 
4  7566 JONES  MANAGER   7839 1981-04-02  2975    NA     20   0.289 
5  7654 MARTIN SALESMAN  7698 1981-09-28  1250  1400     30   0.124 
6  7698 BLAKE  MANAGER   7839 1981-03-01  2850    NA     30   0.278 

 

 

---

5. R sqldf Package

• Contributed Files : https://www.sqlite.org/contrib?orderby=name

R Programming

%%R

sqldf("select ATAN(.3) Arc_Tangent ")

 

Results

  Arc_Tangent
1   0.2914568

 

---

수치형 목록 예제

R Programming

%%R

sqldf("select ATAN(sal/10000) Arc_Tangent from emp")[1:5,]

 

Results

[1] 0.07982999 0.15865526 0.12435499 0.28916164 0.12435499

 

 

---

6. Python pandasql Package

 

Python Programming

ps.sqldf(" select atan(.3) ")

 

---

프로그래밍 결과 출력 방식

Python Programming

import pandasql as ps
var = math.atan(.3)

query = "SELECT {}  ".format(var)
ps.sqldf(query, globals())

 

Results

	0.2914567944778671
0	0.291457

 

 

---

7. R data.table Package

 

R Programming

%%R

DT <- data.table(emp)

DT[, sal_atan := atan(sal / 10000)][1:5,]

 

Results

   empno  ename      job  mgr   hiredate  sal comm deptno   sal_atan
1:  7369  SMITH    CLERK 7902 1980-12-17  800   NA     20 0.07982999
2:  7499  ALLEN SALESMAN 7698 1981-02-20 1600  300     30 0.15865526
3:  7521   WARD SALESMAN 7698 1981-02-22 1250  500     30 0.12435499
4:  7566  JONES  MANAGER 7839 1981-04-02 2975   NA     20 0.28916164
5:  7654 MARTIN SALESMAN 7698 1981-09-28 1250 1400     30 0.12435499

 

---

8. Python Duckdb의 SQL

 

Python Programming

%%sql
  SELECT ATAN(.3) "Arc_Tangent"

 

Python Programming

duckdb.sql(" SELECT ATAN(.3) Arc_Tangent ").df()

 

Results

   Arc_Tangent
0     0.291457

 

---

[Oracle, Pandas, R Prog, Dplyr, Sqldf, Pandasql, Data.Table] 오라클 함수와 R & Python 비교 사전 목록 링크

 

오라클 SQL 함수(Oracle SQL Function) 목록 리스트 링크

 

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