pandas의 dataframe 사용시, SQL의 count(distinct colName) 문법을 사용하고 싶을 때 사용하는 함수
Syntax:
Series.value_counts(normalize=False, sort=True, ascending=False, bins=None, dropna=True)
예시:
링크:
https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.Series.value_counts.html
pandas.Series.value_counts — pandas 1.2.4 documentation
Rather than count values, group them into half-open bins, a convenience for pd.cut, only works with numeric data.
pandas.pydata.org
https://stackoverflow.com/questions/15411158/pandas-countdistinct-equivalent
Pandas count(distinct) equivalent
I am using pandas as a db substitute as I have multiple databases (oracle, mssql, etc) and I am unable to make a sequence of commands to a SQL equivalent. I have a table loaded in a DataFrame with...
stackoverflow.com
반응형
'기초 튼튼 > 시행착오노트' 카테고리의 다른 글
| [elastic beanstalk 에러 해결] The instance profile aws-elasticbeanstalk-ec2-role associated with the environment does not exist. (0) | 2023.09.09 |
|---|---|
| [시행착오노트] AWS RDS 로컬 피시에서 접근하기 (0) | 2023.03.22 |
| [시행착오노트] MySQL rank 함수 구현 (0) | 2021.06.18 |
| [시행착오노트] RDB 접속용 Sequel pro 빌드버전 (0) | 2021.06.15 |
| [시행착오노트] Pandas에서 astype 사용시 Null값을 남기고 싶은 경우 (0) | 2021.03.09 |
