Using TabularData: Import DataFrame to app without data struct?

Question

Created Jan ’22

Replies 1

Boosts 0

Participants 2

The TabularData framework is pretty new (and I am new to Swift), so I haven't found much documentation on the internet. I need to import data from small spreadsheets (converted to .csv), and would like to use DataFrame but am running into the problem that a function cannot return an array (unless there is a premade struct to handle it). My csv files are small and only strings, but they change every day...I have up till now been reading them in line by line, but hope to use the new framework. print(dataframe) gives me just what I want, is there any way to inject it into my app without reading line by line?

if let testUrl = Bundle.main.url(forResource: "Timeslot template", withExtension: "csv") {
    do{
      let tsArray = try DataFrame(contentsOfCSVFile: testUrl, options: options)
      print(tsArray)  //How can I get this output into an array in the app?
      
       
    } catch {
      print(error)
      
    }
  }

Boost

Answer 1

Frameworks Engineer OP

Apple

Jan ’22

Do you want an array of each row or an array of each column? If you want an array of a column you can do Array(dataFrame["myColumn", String.self]). If you want an array of a row you will have to do something like this (assuming all columns are of type String):

let stringColumns: [Column<String>] = dataFrame.columns.map {
    $0.assumingType(String.self)
}

for row in dataFrame.rows.indices {
    let stringRow = stringColumns.map({ $0[row] })
    print(stringRow)
}

0