Let's Code with Vivek

 The Objective of this article is to transform data set from row to column using explode() method. The scope of this article is to understand how to  unnest or explode a data set using parallel processing framework Pyspark and Python native library- Pandas . Dataset looks like as below: dept,name 10,vivek#ruby#aniket 20,rahul#john#amy 30,shankar#jagdish 40, 50,yug#alex#alexa Pandas explode() import pandas as pd pan_df=pd.read_csv(r'explode.csv') df_exp=pan_df.assign(name=pan_df['name'].str.split('#')).explode('name') df_exp Output: Dataset is transformed successfully and we are able to create new rows from nested dataset. Pandas way of explode is simple, crisp and straight forward unless the dataset is complex. In next section of this article we will cover PySpark way of exploding or unnesting dataset. PySpark explode() Import libraries and Connect to Spark from pyspark import SparkContext,SparkConf import pyspark from pyspark.sql import SparkSes...

Data can be in any format, recently I have got chance to work on excel data sets. However we have pandas as very efficient library to work with different types of datasets but, pandas degrades performance whenever data size goes beyond MBs to GBs. For efficient processing of GBs datasets parallel computing was designed and Spark shines here. And we have a library named  com.crealytics:spark-excel_xxx, this package allows querying Excel spreadsheets as Spark Data Frames and leverage the parallel computing infrastructure. The Objective of this article is to understand the usage of spark-excel library with python version of spark or Pyspark. Connect to spark (standalone cluster) import pyspark from pyspark.sql import SparkSession spark=SparkSession.builder \ .appName('Spark_DB') .config("spark.jars.packages", "com.crealytics:spark-excel_2.11:0.12.2") \ .getOrCreate() com.crealytics:spark-excel_2.11:0.12.2 is the creaytics spark-excel package used fo...