How many orders are there per restaurant at Rappi in a real-time analysis with Spark-Databricks-Kafka and GCP?

Where should we lower off ordering out pricing to help the commerces?

Introduction

Step By Step

{'purchase_ID': 1, 'Date at created': '12-10-2020 12:59:08.903724', 'Category': 'Sushi', 'Name': 'Sushi Reel', 'Purchase Price': 35000, 'Delivery Price': 4700, 'Total': 39700}
{'purchase_ID': 2, 'date at created': '12-10-2020 12:59:08.916733', 'Category': 'Desayunos · Panadería', 'Name': 'Ficchi Panadería', 'Purchase Price': 12500, 'Delivery Price': 3100, 'Total': 15600}
Archies Desayunos - 41         
El Fogón Castellano - 40
Campocina - 37
Uma Cantina Peruana - 37
El Inglés Gastro Pub - 36
Piatto - Pizza - 36
La Gran Cazuela - 34
Cazuelitas 93 - 34
El Portal de la Antigua 34
Agua Dulce - 34

Carbón & Mondongos
16
Calentao Express 16
Fratelli - Desayunos 15
Sunny Breakfast Brunch 15
Ventura Soup y Salad 15
OAK Ahumado y Brebajes 15
Pollos Century 15
Thai Station 14
Juliana Restaurante 13
18 Scalini 12

Conclusion :

Data Engineer passionate for automating tasks , Big Data and cutting-edge Technologies