Part 17: Data Manipulation in Advanced Filtering and Conditional Logic

It looks like the code snippet was cut off at the end. I'll complete it and ensure all steps are properly executed to provide a comprehensive analysis for customer segmentation in a retail context.

Here is the continuation and completion of your script:

python
 
1# Final Campaign Target Segment
2print("\n" + "=" * 80)
3print("FINAL CAMPAIGN TARGET SEGMENT")
4print("=" * 80)
5
6# Define criteria for final campaign target segment
7final_segment = df_analysis[
8    (df_analysis['engagement_tier'].isin(['Medium', 'High'])) &
9    (df_analysis['value_tier'].isin(['Medium', 'High'])) &
10    (df_analysis['last_purchase_days_ago'] <= 30)
11]
12
13print("\nFinal campaign target segment criteria:")
14print("Engagement tier: Medium or High")
15print("Value tier: Medium or High")
16print("Last purchase within the last 30 days")
17
18# Display final segment details
19print(f"\nNumber of customers in final segment: {len(final_segment)}")
20print(final_segment[['customer_id', 'email', 'engagement_tier', 'value_tier', 
21                     'last_purchase_days_ago', 'total_purchases']])
22``
23
24[Read the full article at Towards AI - Medium](https://pub.towardsai.net/part-17-data-manipulation-in-advanced-filtering-and-conditional-logic-4e7b83df388b?source=rss----98111c9905da---4)
25
26---
27
28**Want to create content about this topic?** [Use Nemati AI tools](https://nemati.ai) to generate articles, social posts, and more.