Pulling a CSV file in xCode

[ThomasJimenez23]

Hello All,

I am having a hard time pulling information from a file in xcode, I have tried dragging and dropping it into the program. I am not sure what to do...is it something wrong with my code? Am I not calling to the right file?

#include <fstream>
#include <iostream>
#include <sstream>
#include <string>

using namespace std;

struct dataRecord {
    
    string borough;
    string law_category;
    string offense_desciption;
    string station_name;
    
};

bool readCSVtoArray (string, dataRecord[], int);
void printRecord(dataRecord);
void print5(dataRecord[]);

int numMisdemeanor(dataRecord[], int);
void printBrooklynData(dataRecord[], int);

int main(){
    
    string filename = "NYPDcomplaints.csv";
    const int size = 6053;
    dataRecord myRecords[size];
    
    if (!readCSVtoArray(filename, myRecords, size)){
        cout << "Could not read file.";
    }
    else {
        print5(myRecords);
        cout << "\nFalse Misdemeanor: " << numMisdemeanor(myRecords, size);
        cout << "\nBrooklyn: Misdemeanor:\n";
        printBrooklynData(myRecords, size);
    }
    return 0;
}

bool readCSVtoArray (string fn, dataRecord recArray[], int size) {
    
    bool success = false;
    ifstream infile;
    string line;
    
    infile.open(fn.c_str());
    if (infile) {
        cout << "File opened\n";
        getline(infile, line);
        for (int i = 0; i < size; i++) {
            getline(infile, line);
            istringstream rowData(line);
            
            getline(rowData, recArray[i].borough, ',');
            getline(rowData, recArray[i].law_category, ',');
            getline(rowData, recArray[i].offense_desciption, ',');
            getline(rowData, recArray[i].station_name, ',');
        }
        
        success = true;
    }
    
    return success;
}

void printData(dataRecord record) {
    cout << "\nBorough: " << record.borough << endl;
    cout << "\nIncident Law Category: " << record.law_category << endl;
    cout << "\nIncident Offense Description: " << record.offense_desciption <<endl;
    cout << "\nAverage Station Name: " << record.station_name << endl;
}

void print5(dataRecord recArray[]) {
    cout << "First 5 records: \n";
    for (int i = 0; i < 5; i++) {
        printData(recArray[i]);
    }
}

int numMisdemeanor(dataRecord recArray[], int size) {
    int MisdemeanorCount = 0;
    for (int i = 0; i < size; i++) {
        if (recArray[i].law_category == "Misdemeanor")
            MisdemeanorCount += stoi(recArray[i].law_category);
    }
    return MisdemeanorCount;
}

void printQueensData(dataRecord recArray[], int size) {
    for (int i = 0; i < size; i++) {
        if (recArray[i].borough == "Brooklyn" && recArray[i].law_category == "Misdemeanor")
            printData(recArray[i]);
    }
}

[salem c]

> const int size = 6053;
Is your input file always exactly this number of lines long?

Because you'd be much better off with
vector<dataRecord> myRecords;

> getline(rowData, recArray[i].borough, ',');
So long as all your records are simple unquoted strings, this will suffice.
But if you have something like this, it will blindly accept the comma in the quoted string as a field separator.
"field with ,",field2,field3

> MisdemeanorCount += stoi(recArray[i].law_category);
You just established law_category as the string "Misdemeanor". Why are you trying to convert it to an integer?
Perhaps just increment the variable instead.