I want to count the unique date with multiple column, I use "pd.value_counts" ,but it only can count single column.
import os
import sys
import pandas as pd
import numpy as np
from dateutil.parser import *
from datetime import *
df = pd.read_csv('test.csv',encoding='utf8')
a= {"date":df.date,
"good":df.good,
"bad":df.bad,
"normal":df.norma
}
df2=pd.DataFrame(a)
print(df2)
output:
date bad normal good
0 2017-09-16 1 0 0
1 2017-09-16 0 1 0
2 2017-09-20 0 0 1
3 2017-09-20 0 0 1
4 2017-09-22 0 1 0
Have any function in Pandas can count unique date like this
date bad normal good
0 2017-09-16 1 1 0
1 2017-09-20 0 0 2
2 2017-09-22 0 1 0