2

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
Steven
  • 55
  • 6

0 Answers0