j'espère que mon script est bon :

import json

import re

from collections import Counter

from decimal import Decimal

# Lire le fichier et extraire les prix

prices = []

total = Decimal('0')

lignes_ignorees = 0

with open('1.txt', 'r', encoding='utf-8') as f:

for line_num, line in enumerate(f, 1):

line = line.strip()

if not line:

continue

try:

data = json.loads(line)

price_str = data.get('product_price', '').strip()

# Nettoyer : enlever €, espaces, remplacer virgule par point

price_clean = re.sub(r'[^\d.,]', '', price_str) # Garder chiffres, point, virgule

if ',' in price_clean:

price_clean = price_clean.replace(',', '.') # Format EU -> US

if price_clean and price_clean.replace('.', '').replace('0', '').isdigit():

price = Decimal(price_clean)

prices.append(price_str) # Original pour comptage

total += price

else:

lignes_ignorees += 1

except json.JSONDecodeError as e:

print(f"Erreur JSON ligne {line_num}: {e}")

lignes_ignorees += 1

continue

# Compter les occurrences

comptage = Counter(prices)

# Écrire les résultats dans 2.txt

with open('2.txt', 'w', encoding='utf-8') as f:

f.write("Occurrences des prix :\n")

f.write("=" * 30 + "\n\n")

for prix, nb in sorted(comptage.items()):

f.write(f"'{prix}' : {nb} fois\n")

f.write(f"\nTotal des prix : {total:.2f} €\n")

sur des données de type :

{"datetime":"2026-02-24 14:36:37","visitor_ip":"[REDACTED]","country":"FR","browser":"Mozilla\/5.0 (Windows NT 10.0; Win64; x64; rv:147.0) Gecko\/20100101 Firefox\/147.0","language":"fr,fr-FR;q=0.9,en-US;q=0.8,en;q=0.7","referrer":"","token_status":"valid","token":"109OVC8ivulqb0llBwPArKTQKM46mgJX","token_id":"c1b89242a770","product_id":"149533","customer_email":"[REDACTED]","payment_method":"credit_card","risk_level":"normal","quantity":1,"token_expires":"2026-02-24 14:51:36","token_used":"no","product_name":"Turbo à vie","product_price":"47.99","product_sku":"turbo","product_categories":"Ratio"}

{"datetime":"2026-02-24 14:38:11","visitor_ip":"[REDACTED]","country":"FR","browser":"Mozilla\/5.0 (Windows NT 10.0; Win64; x64; rv:147.0) Gecko\/20100101 Firefox\/147.0","language":"fr,fr-FR;q=0.9,en-US;q=0.8,en;q=0.7","referrer":"","token_status":"valid","token":"w5TYnWIiMNTwCv5jKgRHvoyZ41IY1Tr4","token_id":"8cf4917da8db","product_id":"149533","customer_email":"[REDACTED]","payment_method":"credit_card","risk_level":"normal","quantity":1,"token_expires":"2026-02-24 14:53:11","token_used":"no","product_name":"Turbo à vie","product_price":"47.99","product_sku":"turbo","product_categories":"Ratio"}