<reponame>kvnkho/demos<filename>meetups/rochester_data_science/instacart-sample.py
from pyspark.sql import SparkSession
spark = SparkSession.builder.getOrCreate()

df = spark.read.format('csv').options(header='true', inferSchema='true').load('s3://kaggle-data-instacart/products.csv')

df.show()

df.groupby("aisle_id").count().show()
from pyspark.sql import SparkSession
spark = SparkSession.builder.getOrCreate()

df = spark.read.format('csv').options(header='true', inferSchema='true').load('s3://kaggle-data-instacart/products.csv')

df.show()

df.groupby("aisle_id").count().show()