Fire up GraphLab Create

We always start with this line before using any part of GraphLab Create



In [2]:

    
import graphlab

Load a tabular data set



In [3]:

    
sf = graphlab.SFrame('people-example.csv')









    



[INFO] This non-commercial license of GraphLab Create is assigned to j.ryan.rembert@gmail.comand will expire on October 13, 2016. For commercial licensing options, visit https://dato.com/buy/.

[INFO] Start server at: ipc:///tmp/graphlab_server-42131 - Server binary: /Users/jrrembert/venvs/dato-env/lib/python2.7/site-packages/graphlab/unity_server - Server log: /tmp/graphlab_server_1444867670.log
[INFO] GraphLab Server Version: 1.6.1






    



PROGRESS: Finished parsing file /Users/jrrembert/Projects/cybernetic-organism/dato/people-example.csv
PROGRESS: Parsing completed. Parsed 7 lines in 0.022502 secs.
------------------------------------------------------
Inferred types from first line of file as 
column_type_hints=[str,str,str,int]
If parsing fails due to incorrect types, you can correct
the inferred type list above and pass it to read_csv in
the column_type_hints argument
------------------------------------------------------
PROGRESS: Finished parsing file /Users/jrrembert/Projects/cybernetic-organism/dato/people-example.csv
PROGRESS: Parsing completed. Parsed 7 lines in 0.009693 secs.

SFrame basics



In [26]:

    
sf #We can view first few lines of table









    Out[26]:





    
        First Name
        Last Name
        Country
        age
        Full Name
    
    
        Bob
        Smith
        United States
        24
        Bob Smith
    
    
        Alice
        Williams
        Canada
        23
        Alice Williams
    
    
        Malcolm
        Jone
        England
        22
        Malcolm Jone
    
    
        Felix
        Brown
        United States
        23
        Felix Brown
    
    
        Alex
        Cooper
        Poland
        23
        Alex Cooper
    
    
        Tod
        Campbell
        United States
        22
        Tod Campbell
    
    
        Derek
        Ward
        Switzerland
        25
        Derek Ward
    

[7 rows x 5 columns]



In [5]:

    
sf.tail()  # view end of the table









    Out[5]:





    
        First Name
        Last Name
        Country
        age
    
    
        Bob
        Smith
        United States
        24
    
    
        Alice
        Williams
        Canada
        23
    
    
        Malcolm
        Jone
        England
        22
    
    
        Felix
        Brown
        USA
        23
    
    
        Alex
        Cooper
        Poland
        23
    
    
        Tod
        Campbell
        United States
        22
    
    
        Derek
        Ward
        Switzerland
        25
    

[7 rows x 4 columns]

GraphLab Canvas



In [6]:

    
# .show() visualizes any data structure in GraphLab Create
sf.show()









    



Canvas is accessible via web browser at the URL: http://localhost:51631/index.html
Opening Canvas in default web browser.



In [7]:

    
# If you want Canvas visualization to show up on this notebook, 
# rather than popping up a new window, add this line:
graphlab.canvas.set_target('ipynb')



In [27]:

    
sf['age'].show(view='Numeric')

Inspect columns of dataset



In [9]:

    
sf['Country']









    Out[9]:





dtype: str
Rows: 7
['United States', 'Canada', 'England', 'USA', 'Poland', 'United States', 'Switzerland']



In [10]:

    
sf['age']









    Out[10]:





dtype: int
Rows: 7
[24, 23, 22, 23, 23, 22, 25]

Some simple columnar operations



In [31]:

    
sf['age'].mean()









    Out[31]:





23.142857142857146



In [12]:

    
sf['age'].max()









    Out[12]:





25

Create new columns in our SFrame



In [13]:

    
sf









    Out[13]:





    
        First Name
        Last Name
        Country
        age
    
    
        Bob
        Smith
        United States
        24
    
    
        Alice
        Williams
        Canada
        23
    
    
        Malcolm
        Jone
        England
        22
    
    
        Felix
        Brown
        USA
        23
    
    
        Alex
        Cooper
        Poland
        23
    
    
        Tod
        Campbell
        United States
        22
    
    
        Derek
        Ward
        Switzerland
        25
    

[7 rows x 4 columns]



In [14]:

    
sf['Full Name'] = sf['First Name'] + ' ' + sf['Last Name']



In [15]:

    
sf









    Out[15]:





    
        First Name
        Last Name
        Country
        age
        Full Name
    
    
        Bob
        Smith
        United States
        24
        Bob Smith
    
    
        Alice
        Williams
        Canada
        23
        Alice Williams
    
    
        Malcolm
        Jone
        England
        22
        Malcolm Jone
    
    
        Felix
        Brown
        USA
        23
        Felix Brown
    
    
        Alex
        Cooper
        Poland
        23
        Alex Cooper
    
    
        Tod
        Campbell
        United States
        22
        Tod Campbell
    
    
        Derek
        Ward
        Switzerland
        25
        Derek Ward
    

[7 rows x 5 columns]



In [16]:

    
sf['age'] * sf['age']









    Out[16]:





dtype: int
Rows: 7
[576, 529, 484, 529, 529, 484, 625]

Use the apply function to do a advance transformation of our data



In [17]:

    
sf['Country']









    Out[17]:





dtype: str
Rows: 7
['United States', 'Canada', 'England', 'USA', 'Poland', 'United States', 'Switzerland']



In [18]:

    
sf['Country'].show()



In [32]:

    
def transform_country(country):
    if country == 'United States':
        return 'USA'
    else:
        return country



In [20]:

    
transform_country('Brazil')









    Out[20]:





'Brazil'



In [21]:

    
transform_country('Brasil')









    Out[21]:





'Brasil'



In [22]:

    
transform_country('USA')









    Out[22]:





'United States'



In [33]:

    
sf['Country'].apply(transform_country)









    Out[33]:





dtype: str
Rows: 7
['USA', 'Canada', 'England', 'USA', 'Poland', 'USA', 'Switzerland']



In [35]:

    
sf['Country'] = sf['Country'].apply(transform_country)



In [36]:

    
sf









    Out[36]:





    
        First Name
        Last Name
        Country
        age
        Full Name
    
    
        Bob
        Smith
        USA
        24
        Bob Smith
    
    
        Alice
        Williams
        Canada
        23
        Alice Williams
    
    
        Malcolm
        Jone
        England
        22
        Malcolm Jone
    
    
        Felix
        Brown
        USA
        23
        Felix Brown
    
    
        Alex
        Cooper
        Poland
        23
        Alex Cooper
    
    
        Tod
        Campbell
        USA
        22
        Tod Campbell
    
    
        Derek
        Ward
        Switzerland
        25
        Derek Ward
    

[7 rows x 5 columns]



In [46]:

    
sf[0]['Country'] = 'United States'



In [51]:

    
sf









    Out[51]:





    
        First Name
        Last Name
        Country
        age
        Full Name
    
    
        Bob
        Smith
        USA
        24
        Bob Smith
    
    
        Alice
        Williams
        Canada
        23
        Alice Williams
    
    
        Malcolm
        Jone
        England
        22
        Malcolm Jone
    
    
        Felix
        Brown
        USA
        23
        Felix Brown
    
    
        Alex
        Cooper
        Poland
        23
        Alex Cooper
    
    
        Tod
        Campbell
        USA
        22
        Tod Campbell
    
    
        Derek
        Ward
        Switzerland
        25
        Derek Ward
    

[7 rows x 5 columns]



In [ ]:

First Name	Last Name	Country	age	Full Name
Bob	Smith	United States	24	Bob Smith
Alice	Williams	Canada	23	Alice Williams
Malcolm	Jone	England	22	Malcolm Jone
Felix	Brown	United States	23	Felix Brown
Alex	Cooper	Poland	23	Alex Cooper
Tod	Campbell	United States	22	Tod Campbell
Derek	Ward	Switzerland	25	Derek Ward