pklshop 0.0.3

A library for accessing and analyzing Pickleball data from pklmart

pklshop

A library for accessing and analyzing Pickleball data from pklmart. You can find the full documentation here.

Install

Install using:

pip install pklshop

How to use

First, you’ll need to setup a database.ini file (it’s only about 5 lines). This should be stored in the pklshop root directory. Check out connect for an example of how to write this.

Once that’s done, this lib provides a function get_tab_as_df you can use to create and display tables within the database

Available tables are:

table_names

['tournament',
 'match',
 'game',
 'rally',
 'shot_type_ref',
 'shot',
 'player',
 'team']

match_df = get_tab_as_df("match")
game_df = get_tab_as_df("game")
match_df.head()

<style scoped> .dataframe tbody tr th:only-of-type { vertical-align: middle; }

.dataframe tbody tr th {
    vertical-align: top;
}

.dataframe thead th {
    text-align: right;
}

</style>

	match_id	tourn_id	consol_ind	team_id_1	team_id_2	maint_dtm	maint_app	create_dtm	create_app
0	M1	T1	N	T1	T2	2022-04-09 03:19:33.840951+00:00	postgres	2022-04-09 03:19:33.840951+00:00	postgres
1	M2	T2	N	T2	T3	2022-05-26 00:45:11.301752+00:00	postgres	2022-05-26 00:45:11.301752+00:00	postgres
2	M5	T5	N	T6	T5	2022-06-28 00:40:22.948360+00:00	postgres	2022-06-28 00:40:22.948360+00:00	postgres
3	M6	T6	N	T5	T7	2022-07-07 23:01:45.921540+00:00	postgres	2022-07-07 23:01:45.921540+00:00	postgres
4	M7	T7	N	T8	T9	2022-07-11 02:40:50.597016+00:00	postgres	2022-07-11 02:40:50.597016+00:00	postgres

g = Game("G1")
g.summarize_game()

Anna Leigh Waters & Leigh Waters beat Jesse Irvine & Catherine Parenteau 12-10 in game G1
                Player  Error %  Winner %
0         Jesse Irvine    17.46      9.52
1  Catherine Parenteau     1.59      0.00
2    Anna Leigh Waters     1.59      3.17
3         Leigh Waters     9.52      4.76

To see a more complete analysis in action, check out the examples. Also check out Connor and this analysis by conner-mcnicholas on timeout momentum!

r = Rally(“R1020”) r.animate_rally()