}Gj dZddlZddlZddlZej j ej jej je dddddZ ej j ej jej je dddddZ d Z e \Z Zd ed ed edzfd Zy)u app/services/market_price_service.py Direct market price lookup from Agmarknet data. Returns current price per kg and per quintal for a crop in a district. No SARIMAX forecasting — uses actual recorded prices directly. Nz..data processedzmarket_prices_clean.csvlookupzcommodity_name_map.jsonc tjt}|djj jj |d<|djj jj |d<t t5}tj|}ddd|fS#1swY xYw#t$r }tjifcYd}~Sd}~wwxYw)Ndistrict commodity) pdread_csv _MARKET_CSVstrlowerstripopen _MAP_PATHjsonload Exception DataFrame)dffname_mapes NC:\Crop_Prediction\Backend\crop-ai-system\app\services\market_price_service.py_loadrs" [[ %Z.,,22488>>@:[/--33599??A; )_ $yy|H $8| $ $ "||~r!!"s6BCB<0 C<CC C1C,&C1,C1croprreturnc ftjry|jj}tj ||}|jj}ttd|k(}|jry||d|k(}|jr|}|j d}tt|ddtt|ddtt|ddtt|d dt|dd t|j d d d S)z Returns price data for a crop in a district. Tries district-specific price first, falls back to state-wide average. Returns None if no price data available for this crop. Nrrrmodal_price_per_kgmin_price_per_kgmax_price_per_kgmodal_price_per_quintal Agmarknet arrivaldate)rr r!r" district_usedsourcedate) _dfemptyr r _name_mapgetilocroundfloatr )rr crop_lowerr dist_lowerrows dist_rowsrows r get_pricer5%s  yy##%Jz:6I!'')J s;9, -D zzT*%34I .. C$)s3G/H)I1#M#(s3E/F)G#K#(s3E/F)G#K#(s3L/M)NPQ#R#&s:#7#.#&sww}b'A#B )__doc__rospandasr pathnormpathjoindirname__file__r rrr)r+r dictr5r6rrAs ggGGLL*D$ Mfg  GG  GGLL*D$Jcd  "Y"C"3"4$;"r6