FLOOR 오라클 함수 [Oracle, Pandas, R Prog, Dplyr, Sqldf, Pandasql, Data.Table, DuckDB]

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

---

[ FLOOR Oracle Function ]

 

---

FLOOR 함수는 지정한 숫자보다 작거나 같은 정수 중에서 최댓값을 반환한다.

 

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

 

---

1. Oracle(오라클)

 

Oracle Programming

SELECT FLOOR(15.7) "Floor"
FROM   DUAL;

 

Results

Floor
----------------------------
15

 

 

---

2. Python Pandas(파이썬)

 

Python Programming

math.floor(15.7)

 

Results

15

 

 

 

---

3. R Programming (R Package)

 

R Programming

%%R

floor(15.7)

 

Results

[1] 15

 

---

4. R Dplyr Package

 

R Programming

%%R

emp %>%
  dplyr::mutate(floor_value = floor(sal)) %>%
  head(5)

 

Results

# A tibble: 5 x 9
  empno ename  job        mgr hiredate     sal  comm deptno floor_value
  <dbl> <chr>  <chr>    <dbl> <date>     <dbl> <dbl>  <dbl>       <dbl>
1  7369 SMITH  CLERK     7902 1980-12-17   800    NA     20         800
2  7499 ALLEN  SALESMAN  7698 1981-02-20  1600   300     30        1600
3  7521 WARD   SALESMAN  7698 1981-02-22  1250   500     30        1250
4  7566 JONES  MANAGER   7839 1981-04-02  2975    NA     20        2975
5  7654 MARTIN SALESMAN  7698 1981-09-28  1250  1400     30        1250

 

 

 

 

---

5. R sqldf Package

 

R Programming

%%R

sqldf(" select floor(15.7) floor_value ")

 

Results

  floor_value
1          15

 

 

 

 

---

6. Python pandasql Package

 

Python Programming

import pandasql as ps
var = math.floor(15.7)

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

 

Results

	floor_value
0	15

 

 

 

---

7. R data.table Package

 

R Programming

%%R

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

DT[, floor_value := floor(sal)][, c("ename","job") := NULL][1:7, ]

 

Results

   empno  mgr   hiredate  sal comm deptno floor_value
1:  7369 7902 1980-12-17  800   NA     20         800
2:  7499 7698 1981-02-20 1600  300     30        1600
3:  7521 7698 1981-02-22 1250  500     30        1250
4:  7566 7839 1981-04-02 2975   NA     20        2975
5:  7654 7698 1981-09-28 1250 1400     30        1250
6:  7698 7839 1981-03-01 2850   NA     30        2850
7:  7782 7839 1981-01-09 2450   NA     10        2450

 

---

8. Python DuckDB의 SQL

 

Python Programming

%%sql
  SELECT FLOOR(15.7) "Floor"

 

Python Programming

duckdb.sql(" SELECT FLOOR(15.7) Floor_1 ").df()

 

Results

   Floor_1
0     15.0

 

 

 

---

Lille, France (https://unsplash.com/photos/F6-U5fGAOik)

  --------------------------------------------  

 

[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 예제로 만나는 테이블 데이터 처리 방법 리스트 링크 링크