text_plain_output_1.png image_output_1.png
import pandas as pd               # data frames

points = pd.read_csv('../input/points.csv')
serves = pd.read_csv('../input/serves.csv')
rallies = pd.read_csv('../input/rallies.csv')
events = pd.read_csv('../input/events.csv')

rallies1 = rallies.replace({'__undefined__': 'Out/Net (Not Point)'})
df5 = rallies1.groupby(['server', 'winner']).count().iloc[:, :1]
df5.columns = ['Points Won']
df5