HOw to use CSVLoadOptions ? about dataframe-go HOT 19 CLOSED

csv: invalid field or comment delimiter

from dataframe-go.

UserID,MovieID,Rating,Timestamp
1,1193,5,978300760
1,661,3,978302109
1,914,3,978301968
1,3408,4,978300275
1,2355,5,978824291
1,1197,3,978302268

from dataframe-go.

could you give me a example to use imports.CSVLoadOptions

from dataframe-go.

That error is from csv package from standard library which is used underneath.

https://golang.org/pkg/encoding/csv/

from dataframe-go.

Also the column names in csv data must match in dictate data type (including case)

from dataframe-go.

Also provide Comma setting to ,

from dataframe-go.

could you give me example use CSVLoadOptions please ,very thx

from dataframe-go.

type CSVLoadOptions struct Comma rune Comment rune ,
the rune type int32 ?? but // Comma is the field delimiter.
// The default value is ',' is string

from dataframe-go.

if i need rune set value ?
csvOp.Comma ="," is error

from dataframe-go.

Try single quotes

from dataframe-go.

var csvOp imports.CSVLoadOptions
{0 0 false false map[MOVIEID:0 RATING:0 TIMESTAMP:0 USERID:0] }
fmt.Println(csvOp)

from dataframe-go.

please show me the code to run

from dataframe-go.

For dictate data type, your column names don't match your csv data. The case must match

from dataframe-go.

see me code ,is the correct use CSVLoadOptions style

var ctx = context.Background()
file, err := os.Open(ratingPath)
//strings.NewReader(ratingPath)
var csvOp imports.CSVLoadOptions
//csvOp.Comma = 0
csvOp.DictateDataType =make(map[string]interface{})
csvOp.DictateDataType["USERID"]= float64(0)
csvOp.DictateDataType["MOVIEID"]=float64(0)
csvOp.DictateDataType["RATING"]=float64(0)
csvOp.DictateDataType["TIMESTAMP"]=float64(0)
//csvOp.Comma =","
fmt.Println(csvOp)
ratingDf, err := imports.LoadFromCSV(ctx, file,csvOp)

from dataframe-go.

csvOp.DictateDataType[fieldname ] = fieldvalueInit, I just want to know the running example ,I dont know if I write the correct code style

from dataframe-go.

I'll write up a detailed code sample tomr

from dataframe-go.

thx you much

from dataframe-go.

opts := imports.CSVLoadOptions{
	Comma: ',',
	DictateDataType: map[string]interface{}{
		"UserID": float64(0),
		"MovieID": float64(0),
	},
}

from dataframe-go.

all perfectly running

from dataframe-go.