Function TestAutoDetectColumnType

coltype_test.go:70–151

(t *testing.T)

}

func TestAutoDetectColumnType(t *testing.T) {
	tests := []struct {
		name         string
		data         [][]string
		colIndex     int
		expectedType int
	}{
		{
			name: "String column",
			data: [][]string{
				{"Name", "Age"},
				{"Alice", "30"},
				{"Bob", "25"},
				{"Charlie", "35"},
			},
			colIndex:     0,
			expectedType: colTypeStr,
		},
		{
			name: "Number column",
			data: [][]string{
				{"Name", "Age"},
				{"Alice", "30"},
				{"Bob", "25"},
				{"Charlie", "35"},
			},
			colIndex:     1,
			expectedType: colTypeFloat,
		},
		{
			name: "Date column",
			data: [][]string{
				{"Name", "Date"},
				{"Event1", "2024-01-15"},
				{"Event2", "2024-02-20"},
				{"Event3", "2024-03-10"},
			},
			colIndex:     1,
			expectedType: colTypeDate,
		},
		{
			name: "Mixed column defaults to string",
			data: [][]string{
				{"Name", "Value"},
				{"Item1", "100"},
				{"Item2", "abc"},
				{"Item3", "200"},
			},
			colIndex:     1,
			expectedType: colTypeStr,
		},
		{
			name: "Numeric with NA values",
			data: [][]string{
				{"Name", "Score"},
				{"Test1", "95.5"},
				{"Test2", "NA"},
				{"Test3", "87.3"},