Skip to main content

Enhanced Python Dataframes for Spark/PySpark

Project description

Enhanced Python Dataframes for Spark/PySpark


Spark DataFrames provide a nice interface to datasets that have a schema. Getting data from your code into a DataFrame in Python means creating a Row() object with field names and respective values. Given that you already have a schema with data types per field, it would be nice to easily take an object that represents the row and create the Row() object automatically.

Smartframes allow you to define a class by just creating the schema that represents the fields and datatypes. You can then create an object and set the values like any other Python class. When you are ready to store that in a DataFrame, just call the createRow() method.

The createRow() method will coerce any values into the correct data types, for example, if a field is defined as an IntegerType and the value set in the class is a String, it will attempt to convert the string to an Integer before creating the Row().

This was written when creating Row()’s with Long datatypes and finding that Spark did not handle converting integers as longs when passing values to the JVM. I needed a consistent manner to create Row() for all of my DataFrames.


pip install smartframes


Simply create a class that extends from SmartFrame and define the schema as a sorted list of StructFields. It’s important that the schema is sorted as Spark gets upset if the Row() object is created with fields that are in a different order. Strange, but true.

The skipSelectedFields is a list of field names that you normally would not select when creating a select() statement.

class SimpleTable(SmartFrames):
    schema = StructType( sorted(
        StructField("pk_id", IntegerType()),
        StructField("first_name", StringType()),
        key = lambda x:
    skipSelectedFields = []


        s1 = SimpleTable()
        s1.pk_id = 1
        s1.first_name = 'Don'

        s2 = SimpleTable()
        s2.pk_id = 2
        s2.first_name = 'Dan'
        df = self.sqlCtx.createDataFrame([s1.createRow(), s2.createRow()]), s1.schema)


Version Date Notes
1.1.0 10/6/2015 Performance improvements
1.0.1 10/3/2015 First release of smartframes

Project details

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Files for smartframes, version 1.1.0
Filename, size File type Python version Upload date Hashes
Filename, size smartframes-1.1.0.tar.gz (8.3 kB) File type Source Python version None Upload date Hashes View

Supported by

Pingdom Pingdom Monitoring Google Google Object Storage and Download Analytics Sentry Sentry Error logging AWS AWS Cloud computing DataDog DataDog Monitoring Fastly Fastly CDN DigiCert DigiCert EV certificate StatusPage StatusPage Status page