Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Ramu_i
Creator II
Creator II

Find the top 5 Values in the given list

Hi All,

I have ID provider is there,

I want to find the  top 5 services provided by all id's 

 

Data have

ID Provider
1 ['Lunch', 'Takeaway Available', 'Credit Card', 'Dinner', 'Cash', 'Air Conditioned', 'Indoor Seating', 'Pure Veg']
2 ['Delivery', 'No Alcohol Available', 'Dinner', 'Takeaway Available', 'Lunch', 'Cash', 'Indoor Seating']
3 ['No Alcohol Available', 'Dinner', 'Takeaway Available', 'Breakfast', 'Lunch', 'Cash', 'Delivery', 'Outdoor Seating', 'Air Conditioned', 'Self Service', 'Indoor Seating', 'Digital Payments Accepted', 'Pure Veg', 'Desserts and Bakes']
4 ['Takeaway Available', 'Credit Card', 'Lunch', 'Delivery', 'Breakfast', 'Dinner', 'Smoking Area', 'Dance Floor', 'Pure Veg', 'Indoor Seating', 'Air Conditioned']
5 ['Lunch', 'Serves Alcohol', 'Cash', 'Credit Card', 'Dinner', 'Debit Card', 'Wine', 'Live Music', 'Rooftop', 'Digital Payments Accepted', 'Air Conditioned', 'Smoking Area', 'Dance Floor', 'Live Sports Screening', 'Fullbar', 'Outdoor Seating', 'Beer', 'Indoor Seating', 'Serves Cocktails', 'Table booking recommended', 'Available for Functions', 'Resto Bar', 'Hookah', 'Wifi', 'DJ', 'Live Entertainment', 'City View']
6 ['Credit Card', 'Lunch', 'Delivery', 'Dinner', 'Debit Card', 'Takeaway Available', 'No Alcohol Available', 'Cash', 'Indoor Seating', 'Digital Payments Accepted', 'Air Conditioned', 'Free Parking']
7 ['Dinner', 'Delivery', 'Lunch', 'Cash', 'Takeaway Available', 'Indoor Seating', 'Air Conditioned', 'Pure Veg', 'Table booking recommended']
8 ['Lunch', 'Delivery', 'Credit Card', 'No Alcohol Available', 'Dinner', 'Cash', 'Takeaway Available', 'Debit Card', 'Indoor Seating', 'Air Conditioned']
9 ['Takeaway Available', 'Cash', 'Indoor Seating', 'Desserts and Bakes']
10 ['No Alcohol Available', 'Dinner', 'Delivery', 'Credit Card', 'Lunch', 'Cash', 'Takeaway Available', 'Debit Card', 'Outdoor Seating', 'Table booking recommended', 'Air Conditioned', 'Desserts and Bakes', 'Indoor Seating', 'Free Wifi', 'Digital Payments Accepted']
11 ['Dinner', 'Delivery', 'Credit Card', 'Lunch', 'Serves Alcohol', 'Cash', 'Takeaway Available', 'Debit Card', 'Fullbar', 'Beer', 'Rooftop', 'Table booking recommended', 'Wine', 'Indoor Seating']
12 ['Dinner', 'Delivery', 'Breakfast', 'Lunch', 'Cash', 'Takeaway Available', 'Credit Card', 'Debit Card', 'Indoor Seating', 'Air Conditioned', 'Pure Veg', 'Digital Payments Accepted']
13 ['Serves Alcohol', 'Cash', 'Takeaway Available', 'Debit Card', 'Lunch', 'Delivery', 'Credit Card', 'No Alcohol Available', 'Dinner', 'Table booking not available', 'Table Reservation Not Required', 'Indoor Seating', 'Free Wifi', 'Air Conditioned', 'Axis Bank - Dining Delights', 'Desserts and Bakes', 'Outdoor Seating']
14 ['Lunch', 'Cash', 'No Alcohol Available', 'Dinner', 'Takeaway Available', 'Indoor Seating', 'Pure Veg']

 

Requirement is :

What are the top 5 Provider by all the restaurants

Thank advance.

Ram

 

 

 

 

1 Solution

Accepted Solutions
Or
MVP
MVP

Use SubField() in your script to separate the strings into individual services, and then use a simple Count(), would be the best approach.

 

View solution in original post

1 Reply
Or
MVP
MVP

Use SubField() in your script to separate the strings into individual services, and then use a simple Count(), would be the best approach.