파이썬vs오라클vs판다스 연산자

※파이썬 연산자 정리

 

                         오라클                   vs                  파이썬

 

1. 산술 연산자          +                                              +

                            -                                               -

                            *                                               *

                            /                                               /

                          mod                                            %

                         power                               ** (ex:2**=8)

 

2.비교 연산자           >                                              >

                           >=                                            >=

                            <                                              <

                           <=                                            <=

                            =                                             ==

                           !=                                              !=

 

3.논리 연산자         and                                            &

                           or                                              |

                           not                                            !

 

4. 기타

   비교 연산자    between..and                            <=  &  >=

                          in                                             in

                         is null                                       ==''

                          like                                ^,$,정규식함수

 

 

 

 

■ 기타 비교 연산자를 오라클과 파이썬 그리고 판다스와 비교

                    

            오라클   vs     파이썬     vs      판다스

1.           between..and       <= and >=                 <=  &  >=

2.                 in                            in                              isin

3.              like                  emp_list[1][0]               apply 함수

4.              is null                      ==''                           isnull()