**Python vazifalari** orders_log ma'lumotlari bilan Pandas DataFrame nomi df. 1) Qatorlarni filtrlash: holat "processing" va daromad (revenue) > 50000 va prioritet "high". Natijani ko'rsating. 2) Qoidalar bo'yicha 'revenue_group' ustunini yarating: ‘Small’ (< 50000), ‘Medium’ (50000 <= revenue < 90000), ‘Large’ (>= 90000). So'ng, har bir kategoriya (Category) bo'yicha buyurtmalar sonini hisoblang va natijani ko'rsating. 1) df[(df["state"] == "processing") & (df["revenue"] > 50000) & (df["priority"] == "high")] 2)

2. revenue_group ustunini yaratish uchun pd.cut yoki np.select funksiyasidan foydalanishingiz mumkin. So'ngra, ma'lumotlarni kategoriyalarga bo'ling va buyurtmalar sonini hisoblang:

import numpy as np

conditions = [
    df['revenue'] < 50000,
    (df['revenue'] >= 50000) & (df['revenue'] < 90000),
    df['revenue'] >= 90000
]
choices = ['Small', 'Medium', 'Large']
df['revenue_group'] = np.select(conditions, choices)

# Har bir kategoriya va daromad guruhidagi buyurtma sonini hisoblang
result = df.groupby(['Category', 'revenue_group']).size().reset_index(name='order_count')
print(result)

Ushbu kod yangi ustun yaratadi va har bir kategoriya va daromad guruh uchun buyurtma sonini ko'rsatadigan jadval chiqaradi.