Data Cleaning/Manipulation

Our Data

Sample of data from our .csv file

id, name,       gender,     DOB,            MaritalStatus,  CreditCardType
                    1,  Damaris,    Female,     1973-02-18,     false,          visa-electron
                    2,  Barbe,      Female,     1969-04-10,     true,           americanexpress
                    3,  Belia,      Female,     1960-04-16,     false,          maestro
                    4,  Leoline,    Female,     1995-01-19,     true,           bankcard
                    5,  Valentine,  Female,     1992-04-16,     false,      
                    6,  Rosanne,    Female,     1985-01-05,     true,           bankcard
                    7,  Shalna,     Female,     1956-11-01,     false,          jcb
                    8,  Mordy,      Male,       1990-03-27,     true,           china-unionpay
                    9,  Tristan,    Male,       1998-10-05,     true,       
                    10, Alphonso,   Male,       1992-08-10,     false,          mastercard
            

Modify the Data

CSV data is loaded using "d3.csv".
Update the CreditCardType column so there is not blanks.
Create the crossfilter data set


                d3.csv("data/people.csv", function (errors, peopleData) {

                    peopleData.forEach(function (d) {
                        if (d.CreditCardType == "") {
                            d.CreditCardType = "no data"
                        }
                    });
                    var ndx = crossfilter(peopleData);

                    ...
                }
id, name,       gender,     DOB,            MaritalStatus,  CreditCardType
                        1,  Damaris,    Female,     1973-02-18,     false,          visa-electron
                        2,  Barbe,      Female,     1969-04-10,     true,           americanexpress
                        3,  Belia,      Female,     1960-04-16,     false,          maestro
                        4,  Leoline,    Female,     1995-01-19,     true,           bankcard
                        5,  Valentine,  Female,     1992-04-16,     false,          no data
                        6,  Rosanne,    Female,     1985-01-05,     true,           bankcard
                        7,  Shalna,     Female,     1956-11-01,     false,          jcb
                        8,  Mordy,      Male,       1990-03-27,     true,           china-unionpay
                        9,  Tristan,    Male,       1998-10-05,     true,           no data
                        10, Alphonso,   Male,       1992-08-10,     false,          mastercard