← back to Sanderson Onboard
scripts/__pycache__/parse_trade.cpython-314.pyc
34 lines
+
�aj� � � � R t ^ RIt^ RIt^ RIt^ RIHt ]P P ]P P ] 4 RR4 t
]P ! R4 t ]P ! R4 t
R t. t]! 4 t]P P ]
R4 t]! ]R 4 ;_uu_ 4 RRR4 R* EF� t]P P ]
R
] R 24 t]P P- ]4 ' g KG ]! ]4 ;_uu_ 4 t]P1 4 P3 R 4 U u. uF q P5 4 NK up tRRR4 ] ! ]4 EF w t t ] P? ] 4 t ] ' g K" ] PC 4 w t"t#t$]]%! ^ ] ^,
4 ] U u. uF q ' g K V NK up t&]'! ]&4 ^8� d
]&R+, MR
t(]&' d
]&R,, MR
t)](R8w g ]"]9 d K� ]] ^, ] ^ , t*R;t+t,R
t-] ! ]*4 F� w t.t/]/R8X dR ]0! ].^,
R,R,4 F< t1]
P? ]*]1, 4 t2]2' g K% ]! ]2Pg ^4 4 t+ M ]/R8X dR ]0! ].^,
R,R,4 F< t1]
P? ]*]1, 4 t2]2' g K% ]! ]2Pg ^4 4 t, M ]/Pi R4 ' g K� ]/t-K� ]+e ],f; ]! ]R4 ;_uu_ 4 t5]5Pm ] R]" R]) R]$ R24 RRR4 EK� ]Po ]"4 ]Pq R]"R])R]#R]$R]+R],R ]-/4 EK EK� ]! ]P P ]
R 4 R R
R 7 ;_uu_ 4 t9]Pt ! ]9. R-OR 7 t;];Py 4 ] F t=];P} ]=4 K RRR4 ]?! R ] 4 4 t@]?! R! ] 4 4 tA] Uu. uF* qR, ' g K VR, VR, , NK, uptB]C! R"]'! ]4 R#]@ R$]A R%24 ]B' d) ]C! R&]D! ]B4 R'
R(]%! ]B4 R'
R)]! ]B4 R'
24 R# R# + ' g i EL�; iu up i + ' g i ELV; iu up i + ' g i EL�; i + ' g i L�; iu upi ).zgParse trade-portal PLP innerText dumps in data/ -> data/trade_rows.csv (Sanderson only, trade+SSP USD).N)�meanz..�datazi^([A-Z0-9]{5,12})\s-\s(Wallpaper|Fabric)\s-\s(Live|Discontinued|Limited Stock|New In|New|Coming Soon)\s*$z^\$([\d,]+(?:\.\d+)?)$c �8 � \ V P R R4 4 # )�,� )�float�replace)�ss &�scripts/parse_trade.py�numr s � �5����3�r�*�+� +� zparse_dropped.log�w�
sanderson_z_raw.txt�
r � Sanderson�Trade�SSPzPer �a� z - z (no price)
�mfr_code� pattern_name� product_type�status� trade_usd�ssp_usd�unitztrade_rows.csv)�newline)�
fieldnamesc # �8 " � T F qR , R8H x � K R# 5i)r � WallpaperN� ��.0�rs & r
� <genexpr>r$ + s � � �4�t�!� ��+�%�t�� �c # �8 " � T F qR , R8H x � K R# 5i)r �FabricNr r! s & r
r$ r$ + s � � �<g�bf�]^�~�=N�PX�=X�bf�r% zparsed z Sanderson rows: z wallpaper, z fabriczSSP/Trade min=z.3fz max=z avg=)� wallpaper�fabric����������)r r r r r r r )E�__doc__�re�csv�os�
statisticsr �path�join�dirname�__file__�DATA�compile�CODE�PRICEr �rows�set�seen�DROPLOG�open�cat�fp�exists�fh�read�split�strip�L� enumerate�i�line�match�m�groups�code�ptyper �max�prev�len�brand�name�seg�trade�sspr �j�x�range�k�pm�group�
startswith�dl�write�add�append�f�
DictWriterr
� writeheaderr# �writerow�sum�wp�fb�ratios�print�min)rW r# s 00r
�<module>rk s �� m� � � � �w�w�|�|�B�G�G�O�O�H�-�t�V�<�� �z�z�~���
�
�
�,�-�� +���c�e��
��� � �T�-�.�� �'�#���� !�C� �w�w�|�|�D�:�c�U�(�3�4�B�
�7�7�>�>�"� � �x�
�b���R�r�w�w�y���t�/D�E�/D�!�G�G�I�/D�E����A�,���$�
�*�*�T�
���(��(�(�*���U�6��3�q��1��:�a� �
.� �A�A�a�a� �
.�� �d�)�Q�,�d�2�h�B���T�"�X�2�� �+� ��� �x�
�a��c�!�B�$�K��4� ��s�b�� �S�>�C�A�a��'�z� �q��s�2�b�)�A� �{�{�3�q�6�*�B��r��R�X�X�a�[�!1�5�5� *� �%�x� �q��s�2�b�)�A� �{�{�3�q�6�*�B��r�s�2�8�8�A�;� /�3�� *� �|�|�F�#�#�!�T� "� �=�C�K��g�c�"�"�b�"�(�(�c�U�!�D�6��4�&��F�8�S`�3a�*b�"� � ����� � � �Z��^�D� ��h�W]� ��y��V�D�B� C�- � "�8
�"�'�'�,�,�t� ,�
-�c�"�=�=�� �n�n�Q�"r�s�A�uv� vC� vC� vE�
��1�:�:�a�=�T� >� �4�t�4�4���<g�bf�<g�9g�b�-1�D�T��{�^�^�#��)� �Q�{�^�#�#�T�D�� ���D� �{�+�B�4�|�B�4�w�G� H� �5�>�#�f�+�c�!2�%��F� �C�7H��d�SY�l�[^�M_�`� a�6�G ���� F�����
/� #�"�"��
>�=�� Es[ �(Q;�
"R�,R
�R�" R(�0R(� R- �AS�>S�S�; R �R� R% �- R>
� S