In [1]:
import pandas as pd

In [4]:
df = pd.read_hdf('../data/results/boards_users_df_feb27.h5', 'df')
df.shape


Out[4]:
(1339814, 53)

In [5]:
# Board name for all users.
df['board_name'].value_counts()


Out[5]:
Art                         2642
For the Home                2454
Photography                 2436
Christmas                   2326
My Style                    2134
DIY                         2022
Hair                        1670
Halloween                   1648
Products I Love             1647
Food                        1547
Architecture                1438
Favorite Places & Spaces    1430
Fashion                     1402
Easter                      1367
Quotes                      1312
...
My Life & Giveaways                         1
Caffeine Rush                               1
PATTERN-TEMPLATE                            1
∫ Giraffes ∫                                1
A Work Ethic                                1
Fashion on the Red Carpet                   1
Objects and things                          1
Reclaimed panelling                         1
Pet-friendly Design                         1
Food I Want To Eat: Sweet                   1
Leather Touch                               1
The lion the witch & my kind of Wardrobe    1
Photo Art!                                  1
Life as a Nurse                             1
Health and Food                             1
Length: 778672, dtype: int64

In [6]:
# Board name stats for users who had a board for 'bokeh'.
query = 'bokeh'
ind = df['query_{}'.format(query)]
df['board_name'][ind].value_counts()


Out[6]:
Bokeh              240
Photography         99
Christmas           81
Flowers             77
Art                 71
Halloween           55
DIY                 54
Winter              51
Products I Love     46
Reflections         44
For the Home        44
Summer              44
Easter              44
My Style            43
Architecture        42
...
Collection of Still Photography                    1
WRECK THiS JOURNAL .                               1
Edward Weston                                      1
~SNooPY & FRieNds~                                 1
Stacked                                            1
No Sew Projects                                    1
HO  HO  HO                                         1
PAINT my world                                     1
Botanical                                          1
Not just cheese!!! - Homemade Better Made Hacks    1
"Sparkle" & Bokeh                                  1
Linens And Lace                                    1
❤Peacock⊱(̆̃̃(̆̃̃(̆̃̃⊰❤                            1
*~ WARM & COZY ~*                                  1
Christmas Sketchbook                               1
Length: 40450, dtype: int64