a A<äiüã@shdZddlZddlZddlmZedƒZedƒZe ¡sJe de›ƒe ‚e  ee¡e de›ƒej edd Z e d ee ƒ›d ƒe d  gd ¢¡Ze e ¡Ze e ¡Ze deeƒ›ƒe deeƒ›ƒe d¡Zejgd¢ddZe deeƒ›deeƒeeƒ›dƒejeegddZe d¡jddZejeddde deeƒ›de›ƒdS)zºOne-off: dedupe FT/AET/PEN duplicate rows in live_data.csv. Keeps earliest timestamp for each (game_date, home, away, status) where status is terminal. Preserves all non-terminal rows. éN)ÚPathzE:\soccer\live_data.csvzE:\soccer\live_data.csv.bakz No file at z Backed up to zlatin-1)ÚencodingzLoaded z rowsÚstatus)ZFTZAETZPENz Terminal rows: z Non-terminal rows: Z timestamp)Z game_dateÚhomeZawayrÚfirst)ZsubsetZkeepz After dedup: z terminal rows (removed ú)T)Z ignore_index)ZdropF)ÚindexrzWrote z rows to )Ú__doc__ZpandasZpdZshutilÚpathlibrZCSVZBAKÚexistsÚprintÚ SystemExitZcopy2Zread_csvZdfÚlenZisinZterminalÚcopyZterm_dfZ nonterm_dfZ sort_valuesZdrop_duplicatesZ term_dedupÚconcatÚoutZ reset_indexZto_csv©rrú"E:\soccer\misc\dedupe_live_data.pyÚs6    þ&