<jupyter_start><jupyter_text>Select Only Violations that are DC, Maryland or Virginia<jupyter_code>selected_states = set(['DC', 'MD', 'VA'])
dmv_df = df[(df.rp_plate_state=='DC') | (df.rp_plate_state=='MD') | (df.rp_plate_state=='VA') ]
by_state = dmv_df.groupby('rp_plate_state').counter.sum()
by_state.plot(kind='bar')
by_fines = dmv_df.groupby('rp_plate_state').fine.sum()

by_fines.plot(kind='bar')
dmv_df.set_index("ticket_issue_datetime", inplace=True)
state_by_year = dmv_df.groupby([pd.TimeGrouper('12M'), 'rp_plate_state' ]).fine.sum()
state_by_year.unstack().plot.bar()<jupyter_output><empty_output>
{'fraction_non_alphanumeric': 0.18719211822660098, 'fraction_numerical': 0.003284072249589491, 'mean_word_length': 9.701754385964913, 'pattern_counts': {'":': 0, '<': 5, '<?xml version=': 0, '>': 5, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'chain_length': '1', 'dir': 'jupyter-structured-clean-dedup', 'id': '271420', 'license': 'MIT', 'n_tokens_mistral': 262, 'n_tokens_neox': 247, 'n_words': 29, 'path': 'notebooks/Time Series Analysis - DMV by State.ipynb', 'repo_name': 'ndanielsen/dc_parking_violations_data', 'size': '609'}