1305 references to Columns
Microsoft.Data.Analysis (283)
DataFrame.Arrow.cs (6)
146
ret.
Columns
.Insert(ret.
Columns
.Count, dataFrameColumn);
177
int columnCount =
Columns
.Count;
180
DataFrameColumn column =
Columns
[i];
197
DataFrameColumn column =
Columns
[i];
202
DataFrameColumn column =
Columns
[i];
DataFrame.BinaryOperations.cs (116)
18
if (values.Count !=
Columns
.Count)
24
for (int i = 0; i <
Columns
.Count; i++)
29
retDataFrame.
Columns
[i] = newColumn;
31
retDataFrame.
Columns
.Insert(i, newColumn);
43
for (int i = 0; i <
Columns
.Count; i++)
48
retDataFrame.
Columns
[i] = newColumn;
50
retDataFrame.
Columns
.Insert(i, newColumn);
57
if (values.Count !=
Columns
.Count)
63
for (int i = 0; i <
Columns
.Count; i++)
68
retDataFrame.
Columns
[i] = newColumn;
70
retDataFrame.
Columns
.Insert(i, newColumn);
82
for (int i = 0; i <
Columns
.Count; i++)
87
retDataFrame.
Columns
[i] = newColumn;
89
retDataFrame.
Columns
.Insert(i, newColumn);
96
if (values.Count !=
Columns
.Count)
102
for (int i = 0; i <
Columns
.Count; i++)
107
retDataFrame.
Columns
[i] = newColumn;
109
retDataFrame.
Columns
.Insert(i, newColumn);
121
for (int i = 0; i <
Columns
.Count; i++)
126
retDataFrame.
Columns
[i] = newColumn;
128
retDataFrame.
Columns
.Insert(i, newColumn);
135
if (values.Count !=
Columns
.Count)
141
for (int i = 0; i <
Columns
.Count; i++)
146
retDataFrame.
Columns
[i] = newColumn;
148
retDataFrame.
Columns
.Insert(i, newColumn);
160
for (int i = 0; i <
Columns
.Count; i++)
165
retDataFrame.
Columns
[i] = newColumn;
167
retDataFrame.
Columns
.Insert(i, newColumn);
174
if (values.Count !=
Columns
.Count)
180
for (int i = 0; i <
Columns
.Count; i++)
185
retDataFrame.
Columns
[i] = newColumn;
187
retDataFrame.
Columns
.Insert(i, newColumn);
199
for (int i = 0; i <
Columns
.Count; i++)
204
retDataFrame.
Columns
[i] = newColumn;
206
retDataFrame.
Columns
.Insert(i, newColumn);
212
if (values.Count !=
Columns
.Count)
218
for (int i = 0; i <
Columns
.Count; i++)
223
retDataFrame.
Columns
[i] = newColumn;
225
retDataFrame.
Columns
.Insert(i, newColumn);
236
for (int i = 0; i <
Columns
.Count; i++)
241
retDataFrame.
Columns
[i] = newColumn;
243
retDataFrame.
Columns
.Insert(i, newColumn);
249
if (values.Count !=
Columns
.Count)
255
for (int i = 0; i <
Columns
.Count; i++)
260
retDataFrame.
Columns
[i] = newColumn;
262
retDataFrame.
Columns
.Insert(i, newColumn);
273
for (int i = 0; i <
Columns
.Count; i++)
278
retDataFrame.
Columns
[i] = newColumn;
280
retDataFrame.
Columns
.Insert(i, newColumn);
286
if (values.Count !=
Columns
.Count)
292
for (int i = 0; i <
Columns
.Count; i++)
297
retDataFrame.
Columns
[i] = newColumn;
299
retDataFrame.
Columns
.Insert(i, newColumn);
310
for (int i = 0; i <
Columns
.Count; i++)
315
retDataFrame.
Columns
[i] = newColumn;
317
retDataFrame.
Columns
.Insert(i, newColumn);
328
for (int i = 0; i <
Columns
.Count; i++)
333
retDataFrame.
Columns
[i] = newColumn;
335
retDataFrame.
Columns
.Insert(i, newColumn);
346
for (int i = 0; i <
Columns
.Count; i++)
351
retDataFrame.
Columns
[i] = newColumn;
353
retDataFrame.
Columns
.Insert(i, newColumn);
360
if (values.Count !=
Columns
.Count)
366
for (int i = 0; i <
Columns
.Count; i++)
370
retDataFrame.
Columns
.Insert(i, newColumn);
382
for (int i = 0; i <
Columns
.Count; i++)
386
retDataFrame.
Columns
.Insert(i, newColumn);
393
if (values.Count !=
Columns
.Count)
399
for (int i = 0; i <
Columns
.Count; i++)
403
retDataFrame.
Columns
.Insert(i, newColumn);
415
for (int i = 0; i <
Columns
.Count; i++)
419
retDataFrame.
Columns
.Insert(i, newColumn);
426
if (values.Count !=
Columns
.Count)
432
for (int i = 0; i <
Columns
.Count; i++)
436
retDataFrame.
Columns
.Insert(i, newColumn);
448
for (int i = 0; i <
Columns
.Count; i++)
452
retDataFrame.
Columns
.Insert(i, newColumn);
459
if (values.Count !=
Columns
.Count)
465
for (int i = 0; i <
Columns
.Count; i++)
469
retDataFrame.
Columns
.Insert(i, newColumn);
481
for (int i = 0; i <
Columns
.Count; i++)
485
retDataFrame.
Columns
.Insert(i, newColumn);
492
if (values.Count !=
Columns
.Count)
498
for (int i = 0; i <
Columns
.Count; i++)
502
retDataFrame.
Columns
.Insert(i, newColumn);
514
for (int i = 0; i <
Columns
.Count; i++)
518
retDataFrame.
Columns
.Insert(i, newColumn);
525
if (values.Count !=
Columns
.Count)
531
for (int i = 0; i <
Columns
.Count; i++)
535
retDataFrame.
Columns
.Insert(i, newColumn);
547
for (int i = 0; i <
Columns
.Count; i++)
551
retDataFrame.
Columns
.Insert(i, newColumn);
563
for (int i = 0; i <
Columns
.Count; i++)
568
retDataFrame.
Columns
[i] = newColumn;
570
retDataFrame.
Columns
.Insert(i, newColumn);
581
for (int i = 0; i <
Columns
.Count; i++)
586
retDataFrame.
Columns
[i] = newColumn;
588
retDataFrame.
Columns
.Insert(i, newColumn);
599
for (int i = 0; i <
Columns
.Count; i++)
604
retDataFrame.
Columns
[i] = newColumn;
606
retDataFrame.
Columns
.Insert(i, newColumn);
617
for (int i = 0; i <
Columns
.Count; i++)
622
retDataFrame.
Columns
[i] = newColumn;
624
retDataFrame.
Columns
.Insert(i, newColumn);
635
for (int i = 0; i <
Columns
.Count; i++)
640
retDataFrame.
Columns
[i] = newColumn;
642
retDataFrame.
Columns
.Insert(i, newColumn);
652
for (int i = 0; i <
Columns
.Count; i++)
657
retDataFrame.
Columns
[i] = newColumn;
659
retDataFrame.
Columns
.Insert(i, newColumn);
669
for (int i = 0; i <
Columns
.Count; i++)
674
retDataFrame.
Columns
[i] = newColumn;
676
retDataFrame.
Columns
.Insert(i, newColumn);
686
for (int i = 0; i <
Columns
.Count; i++)
691
retDataFrame.
Columns
[i] = newColumn;
693
retDataFrame.
Columns
.Insert(i, newColumn);
DataFrame.cs (45)
161
get =>
Columns
[columnName];
162
set =>
Columns
[columnName] = value;
200
List<DataFrameColumn> newColumns = new List<DataFrameColumn>(
Columns
.Count);
201
for (int i = 0; i <
Columns
.Count; i++)
203
newColumns.Add(
Columns
[i].Clone(mapIndices));
216
foreach (DataFrameColumn column in
Columns
)
224
ret.
Columns
.Add(strColumn);
226
ret.
Columns
.Add(column.Info());
239
foreach (DataFrameColumn column in
Columns
)
253
ret.
Columns
.Add(stringColumn);
255
ret.
Columns
.Add(column.Description());
292
for (int i = 0; i < ret.
Columns
.Count; i++)
294
DataFrameColumn column = ret.
Columns
[i];
307
for (int i = 0; i < df.
Columns
.Count; i++)
309
DataFrameColumn column = df.
Columns
[i];
322
for (int i = 0; i < df.
Columns
.Count; i++)
324
DataFrameColumn column = df.
Columns
[i];
400
for (int i = 0; i <
Columns
.Count; i++)
402
if (
Columns
[i].Length != rowCount)
403
throw new ArgumentException(String.Format("{0} {1}", Strings.MismatchedRowCount,
Columns
[i].Name));
421
foreach (var column in
Columns
)
441
foreach (var column in
Columns
)
468
for (int i = 0; i < ret.
Columns
.Count; i++)
470
ret.
Columns
[i].FillNulls(value, inPlace: true);
483
if (values.Count !=
Columns
.Count)
487
for (int i = 0; i < ret.
Columns
.Count; i++)
489
Columns
[i].FillNulls(values[i], inPlace: true);
536
IEnumerator<DataFrameColumn> columnEnumerator = ret.
Columns
.GetEnumerator();
575
throw new ArgumentException(string.Format(Strings.ExceedsNumberOfColumns,
Columns
.Count), nameof(row));
578
columnEnumerator = ret.
Columns
.GetEnumerator();
600
ret.
Columns
.RowCount++;
628
int index = ret.
Columns
.IndexOf(columnName);
634
DataFrameColumn column = ret.
Columns
[index];
651
int index = ret.
Columns
.IndexOf(columnName);
653
DataFrameColumn column = ret.
Columns
[index];
659
foreach (DataFrameColumn column in ret.
Columns
)
666
ret.
Columns
.RowCount++;
680
DataFrameColumn column =
Columns
[columnName];
683
List<DataFrameColumn> newColumns = new List<DataFrameColumn>(
Columns
.Count);
684
for (int i = 0; i <
Columns
.Count; i++)
686
DataFrameColumn oldColumn =
Columns
[i];
709
for (int i = 0; i <
Columns
.Count; i++)
711
longestColumnName = Math.Max(longestColumnName,
Columns
[i].Name.Length);
715
for (int i = 0; i <
Columns
.Count; i++)
718
sb.Append(string.Format(
Columns
[i].Name.PadRight(padding)));
DataFrame.IDataView.cs (3)
29
for (int i = 0; i <
Columns
.Count; i++)
31
DataFrameColumn baseColumn =
Columns
[i];
110
DataFrameColumn column = _dataFrame.
Columns
[col];
DataFrame.IO.cs (5)
144
var columnsCount =
Columns
.Count;
148
foreach (var column in
Columns
)
159
if (table.Columns[c].DataType !=
Columns
[c].DataType)
478
ret.
Columns
.Insert(0, indexColumn);
676
SaveHeader(csvFile, dataFrame.
Columns
.GetColumnNames(), separator);
DataFrame.Join.cs (48)
32
DataFrameColumn existingColumn = dataFrame.
Columns
[index];
52
for (int i = 0; i <
Columns
.Count; i++)
54
DataFrameColumn newColumn =
Columns
[i].Clone();
55
ret.
Columns
.Insert(ret.
Columns
.Count, newColumn);
63
for (int i = 0; i < other.
Columns
.Count; i++)
68
newColumn = other.
Columns
[i].Clone(numberOfNullsToAppend: Rows.Count - other.Rows.Count);
72
newColumn = other.
Columns
[i].Clone(mapIndices);
75
ret.
Columns
.Insert(ret.
Columns
.Count, newColumn);
86
for (int i = 0; i <
Columns
.Count; i++)
91
newColumn =
Columns
[i].Clone(numberOfNullsToAppend: other.Rows.Count - Rows.Count);
95
newColumn =
Columns
[i].Clone(mapIndices);
97
ret.
Columns
.Insert(ret.
Columns
.Count, newColumn);
99
for (int i = 0; i < other.
Columns
.Count; i++)
101
DataFrameColumn newColumn = other.
Columns
[i].Clone();
103
ret.
Columns
.Insert(ret.
Columns
.Count, newColumn);
110
for (int i = 0; i <
Columns
.Count; i++)
112
DataFrameColumn newColumn =
Columns
[i].Clone(numberOfNullsToAppend: numberOfNulls);
113
ret.
Columns
.Insert(ret.
Columns
.Count, newColumn);
116
for (int i = 0; i < other.
Columns
.Count; i++)
118
DataFrameColumn newColumn = other.
Columns
[i].Clone(numberOfNullsToAppend: numberOfNulls);
120
ret.
Columns
.Insert(ret.
Columns
.Count, newColumn);
131
for (int i = 0; i <
Columns
.Count; i++)
133
DataFrameColumn newColumn =
Columns
[i].Clone(mapIndices);
134
ret.
Columns
.Insert(ret.
Columns
.Count, newColumn);
136
for (int i = 0; i < other.
Columns
.Count; i++)
138
DataFrameColumn newColumn = other.
Columns
[i].Clone(mapIndices);
140
ret.
Columns
.Insert(ret.
Columns
.Count, newColumn);
204
DataFrameColumn shrinkedRetainedColumn = retainedDataFrame.
Columns
[retainedJoinColumnNames[colNameIndex]];
228
DataFrameColumn supplementaryColumn = supplementaryDataFrame.
Columns
[supplemetaryJoinColumnNames[colNameIndex]];
285
var retainJoinColumns = retainedJoinColumnNames.Select(name => retainedDataFrame.
Columns
[name]).ToArray();
287
for (long i = 0; i < retainedDataFrame.
Columns
.RowCount; i++)
388
for (long i = 0; i < supplementaryDataFrame.
Columns
.RowCount; i++)
390
var columns = supplementaryJoinColumns.Select(name => supplementaryDataFrame.
Columns
[name]).ToArray();
410
for (int i = 0; i < this.
Columns
.Count; i++)
412
ret.
Columns
.Insert(i, this.
Columns
[i].Clone(mapIndicesLeft));
416
for (int i = 0; i < other.
Columns
.Count; i++)
418
DataFrameColumn column = other.
Columns
[i].Clone(mapIndicesRight);
421
ret.
Columns
.Insert(ret.
Columns
.Count, column);
DataFrameRow.cs (5)
24
Debug.Assert(rowIndex < df.
Columns
.RowCount);
34
foreach (DataFrameColumn column in _dataFrame.
Columns
)
42
return _dataFrame.
Columns
.Select(col => new KeyValuePair<string, object>(col.Name, col[_rowIndex]));
54
return _dataFrame.
Columns
[index][_rowIndex];
58
_dataFrame.
Columns
[index][_rowIndex] = value;
DataFrameRowCollection.cs (1)
52
public long Count => _dataFrame.
Columns
.RowCount;
GroupBy.cs (54)
110
if (dataFrame.
Columns
.Count < groupByColumnIndex || groupByColumnIndex < 0)
133
int columnIndex = _dataFrame.
Columns
.IndexOf(columnName);
146
DataFrameColumn firstColumn = _dataFrame.
Columns
[_groupByColumnIndex].Clone(empty);
147
ret.
Columns
.Insert(ret.
Columns
.Count, firstColumn);
157
DataFrameColumn column = _dataFrame.
Columns
[columnIndex];
168
ret.
Columns
.Insert(ret.
Columns
.Count, retColumn);
173
retColumn = ret.
Columns
[column.Name];
189
DataFrameColumn firstColumn = _dataFrame.
Columns
[_groupByColumnIndex].Clone(empty);
190
ret.
Columns
.Insert(ret.
Columns
.Count, firstColumn);
202
DataFrameColumn column = _dataFrame.
Columns
[columnIndex];
209
ret.
Columns
.Insert(ret.
Columns
.Count, retColumn);
214
retColumn = ret.
Columns
[column.Name];
231
DataFrameColumn firstColumn = _dataFrame.
Columns
[_groupByColumnIndex].Clone(empty);
232
ret.
Columns
.Insert(ret.
Columns
.Count, firstColumn);
242
DataFrameColumn column = _dataFrame.
Columns
[columnIndex];
254
ret.
Columns
.Insert(ret.
Columns
.Count, retColumn);
259
retColumn = ret.
Columns
[column.Name];
285
DataFrameColumn firstColumn = _dataFrame.
Columns
[_groupByColumnIndex].Clone(empty);
286
ret.
Columns
.Insert(ret.
Columns
.Count, firstColumn);
296
DataFrameColumn column = _dataFrame.
Columns
[columnIndex];
310
ret.
Columns
.Insert(ret.
Columns
.Count, retColumn);
315
retColumn = ret.
Columns
[column.Name];
339
DataFrameColumn column = _dataFrame.
Columns
[columnIndex];
344
ret.
Columns
.Insert(ret.
Columns
.Count, retColumn);
349
retColumn = ret.
Columns
[column.Name];
359
DataFrameColumn firstColumn = _dataFrame.
Columns
[_groupByColumnIndex].Clone(empty);
360
ret.
Columns
.Insert(ret.
Columns
.Count, firstColumn);
373
retColumn[rowIndex] = _dataFrame.
Columns
[columnIndex].Max(rowEnumerable);
387
DataFrameColumn firstColumn = _dataFrame.
Columns
[_groupByColumnIndex].Clone(empty);
388
ret.
Columns
.Insert(ret.
Columns
.Count, firstColumn);
401
retColumn[rowIndex] = _dataFrame.
Columns
[columnIndex].Min(rowEnumerable);
415
DataFrameColumn firstColumn = _dataFrame.
Columns
[_groupByColumnIndex].Clone(empty);
416
ret.
Columns
.Insert(ret.
Columns
.Count, firstColumn);
429
retColumn[rowIndex] = _dataFrame.
Columns
[columnIndex].Product(rowEnumerable);
443
DataFrameColumn firstColumn = _dataFrame.
Columns
[_groupByColumnIndex].Clone(empty);
444
ret.
Columns
.Insert(ret.
Columns
.Count, firstColumn);
457
retColumn[rowIndex] = _dataFrame.
Columns
[columnIndex].Sum(rowEnumerable);
471
DataFrameColumn firstColumn = _dataFrame.
Columns
[_groupByColumnIndex].Clone(empty);
472
ret.
Columns
.Insert(ret.
Columns
.Count, firstColumn);
486
retColumn[rowIndex] = (double)Convert.ChangeType(_dataFrame.
Columns
[columnIndex].Sum(rowEnumerable), typeof(double)) / rowEnumerable.Count;
Microsoft.Data.Analysis.Interactive (6)
DataFrameKernelExtension.cs (2)
48
header.AddRange(df.
Columns
.Select(c => (IHtmlContent)th(c.Name)));
101
tfoot(tr(td[colspan: df.
Columns
.Count + 1, style: "text-align: center;"](footer)))
TabularDataResourceExtensions.cs (4)
42
dataFrame.
Columns
.Add(new DoubleDataFrameColumn(fieldDescriptor.Name, column.Select(Convert.ToDouble)));
45
dataFrame.
Columns
.Add(new Int64DataFrameColumn(fieldDescriptor.Name, column.Select(Convert.ToInt64)));
48
dataFrame.
Columns
.Add(new BooleanDataFrameColumn(fieldDescriptor.Name, column.Select(Convert.ToBoolean)));
51
dataFrame.
Columns
.Add(new StringDataFrameColumn(fieldDescriptor.Name, column.Select(Convert.ToString)));
Microsoft.Data.Analysis.Interactive.Tests (3)
DataFrameInteractiveTests.cs (3)
30
dataFrame.
Columns
.Insert(0, dataFrameColumn1);
31
dataFrame.
Columns
.Insert(1, dataFrameColumn2);
92
Assert.Equal(dataFrame.
Columns
.Select(c => c.Name).ToArray(), new[] { "TrueOrFalse", "Integer", "Double", "Text" });
Microsoft.Data.Analysis.Tests (1013)
ArrowIntegrationTests.cs (17)
166
Assert.Equal(1, df.
Columns
["Column1"][1]);
167
df.
Columns
["Column1"][1] = 100;
168
Assert.Equal(100, df.
Columns
["Column1"][1]);
169
Assert.Equal(0, df.
Columns
["Column1"].NullCount);
188
Assert.Equal(0, df.
Columns
["EmptyNullBitMapColumn"].NullCount);
189
Assert.Equal(10, df.
Columns
["EmptyNullBitMapColumn"].Length);
190
df.
Columns
["EmptyNullBitMapColumn"][9] = null;
191
Assert.Equal(1, df.
Columns
["EmptyNullBitMapColumn"].NullCount);
192
Assert.Equal(10, df.
Columns
["EmptyDataColumn"].NullCount);
193
Assert.Equal(10, df.
Columns
["EmptyDataColumn"].Length);
194
df.
Columns
["EmptyDataColumn"][9] = 9;
195
Assert.Equal(9, df.
Columns
["EmptyDataColumn"].NullCount);
196
Assert.Equal(10, df.
Columns
["EmptyDataColumn"].Length);
199
Assert.Equal(i, (int)df.
Columns
["EmptyNullBitMapColumn"][i]);
200
Assert.Null(df.
Columns
["EmptyDataColumn"][i]);
207
Assert.Equal(0, emptyDataFrame.
Columns
["EmptyDataAndNullColumns"].Length);
208
Assert.Equal(0, emptyDataFrame.
Columns
["EmptyDataAndNullColumns"].NullCount);
DataFrame.IOTests.cs (151)
27
foreach (DataFrameColumn column in df.
Columns
)
138
Assert.Equal(7, df.
Columns
.Count);
139
Assert.Equal(verifyCMT, df.
Columns
["vendor_id"][3]);
150
Assert.Equal(7, reducedRows.
Columns
.Count);
151
Assert.Equal(verifyCMT, reducedRows.
Columns
["vendor_id"][2]);
172
Assert.Equal(7, df.
Columns
.Count);
222
Assert.Equal(9, df.
Columns
.Count);
223
Assert.Equal("CMT", df.
Columns
["vendor_id"][3]);
225
Assert.Equal("payment_type", df.
Columns
[5].Name);
226
Assert.Equal("payment_type.1", df.
Columns
[6].Name);
227
Assert.Equal("payment_type.2", df.
Columns
[7].Name);
229
Assert.Equal("CRD", df.
Columns
["payment_type"][0]);
230
Assert.Equal("CRD_1", df.
Columns
["payment_type.1"][0]);
231
Assert.Equal("Test", df.
Columns
["payment_type.2"][0]);
251
Assert.Equal(7, df.
Columns
.Count);
252
Assert.Equal(verifyCMT, df.
Columns
["Column0"][3]);
264
Assert.Equal(7, reducedRows.
Columns
.Count);
265
Assert.Equal(verifyCMT, reducedRows.
Columns
["Column0"][2]);
290
Assert.Equal(7, df.
Columns
.Count);
291
Assert.Equal(verifyCMT, df.
Columns
["Column0"][3]);
303
Assert.Equal(7, reducedRows.
Columns
.Count);
304
Assert.Equal(verifyCMT, reducedRows.
Columns
["Column0"][2]);
317
Assert.Equal(7, df.
Columns
.Count);
321
Assert.True(typeof(string) == df.
Columns
[0].DataType);
322
Assert.True(typeof(short) == df.
Columns
[1].DataType);
323
Assert.True(typeof(int) == df.
Columns
[2].DataType);
324
Assert.True(typeof(long) == df.
Columns
[3].DataType);
325
Assert.True(typeof(float) == df.
Columns
[4].DataType);
326
Assert.True(typeof(string) == df.
Columns
[5].DataType);
327
Assert.True(typeof(double) == df.
Columns
[6].DataType);
332
Assert.Equal("vendor_id", df.
Columns
[0].Name);
333
Assert.Equal("rate_code", df.
Columns
[1].Name);
334
Assert.Equal("passenger_count", df.
Columns
[2].Name);
335
Assert.Equal("trip_time_in_secs", df.
Columns
[3].Name);
336
Assert.Equal("trip_distance", df.
Columns
[4].Name);
337
Assert.Equal("payment_type", df.
Columns
[5].Name);
338
Assert.Equal("fare_amount", df.
Columns
[6].Name);
343
foreach (var column in df.
Columns
)
430
Assert.Equal(7, df.
Columns
.Count);
432
Assert.True(typeof(string) == df.
Columns
[0].DataType);
433
Assert.True(typeof(short) == df.
Columns
[1].DataType);
434
Assert.True(typeof(int) == df.
Columns
[2].DataType);
435
Assert.True(typeof(long) == df.
Columns
[3].DataType);
436
Assert.True(typeof(float) == df.
Columns
[4].DataType);
437
Assert.True(typeof(string) == df.
Columns
[5].DataType);
438
Assert.True(typeof(double) == df.
Columns
[6].DataType);
440
Assert.Equal("vendor_id", df.
Columns
[0].Name);
441
Assert.Equal("rate_code", df.
Columns
[1].Name);
442
Assert.Equal("passenger_count", df.
Columns
[2].Name);
443
Assert.Equal("trip_time_in_secs", df.
Columns
[3].Name);
444
Assert.Equal("trip_distance", df.
Columns
[4].Name);
445
Assert.Equal("payment_type", df.
Columns
[5].Name);
446
Assert.Equal("fare_amount", df.
Columns
[6].Name);
449
foreach (var column in df.
Columns
)
489
Assert.Equal(8, df.
Columns
.Count);
493
Assert.True(typeof(string) == df.
Columns
[0].DataType);
494
Assert.True(typeof(short) == df.
Columns
[1].DataType);
495
Assert.True(typeof(int) == df.
Columns
[2].DataType);
496
Assert.True(typeof(long) == df.
Columns
[3].DataType);
497
Assert.True(typeof(float) == df.
Columns
[4].DataType);
498
Assert.True(typeof(string) == df.
Columns
[5].DataType);
499
Assert.True(typeof(double) == df.
Columns
[6].DataType);
500
Assert.True(typeof(DateTime) == df.
Columns
[7].DataType);
503
Assert.Equal("vendor_id", df.
Columns
[0].Name);
504
Assert.Equal("rate_code", df.
Columns
[1].Name);
505
Assert.Equal("passenger_count", df.
Columns
[2].Name);
506
Assert.Equal("trip_time_in_secs", df.
Columns
[3].Name);
507
Assert.Equal("trip_distance", df.
Columns
[4].Name);
508
Assert.Equal("payment_type", df.
Columns
[5].Name);
509
Assert.Equal("fare_amount", df.
Columns
[6].Name);
510
Assert.Equal("date", df.
Columns
[7].Name);
513
foreach (var column in df.
Columns
)
534
var dateTimeColumn = df.
Columns
["date"];
566
Assert.Equal(7, df.
Columns
.Count);
567
Assert.Equal("CMT", df.
Columns
["vendor_id"][4]);
572
Assert.Equal(7, reducedRows.
Columns
.Count);
573
Assert.Equal("CMT", reducedRows.
Columns
["vendor_id"][2]);
605
Assert.Equal(7, df.
Columns
.Count);
606
Assert.Equal("CMT", df.
Columns
["vendor_id"][4]);
611
Assert.Equal(7, reducedRows.
Columns
.Count);
612
Assert.Equal("CMT", reducedRows.
Columns
["vendor_id"][2]);
643
Assert.Equal(7, df.
Columns
.Count);
644
Assert.Equal("CMT", df.
Columns
["vendor_id"][3]);
649
Assert.Equal(7, reducedRows.
Columns
.Count);
650
Assert.Equal("CMT", reducedRows.
Columns
["vendor_id"][2]);
670
var columnName = df.
Columns
.Select(c => c.Name);
685
var columnName = df.
Columns
.Select(c => c.Name);
709
Assert.Equal(2, dataFrame.
Columns
.Count);
710
Assert.Equal("IndexColumn", dataFrame.
Columns
[0].Name);
711
Assert.Equal(3, dataFrame.
Columns
[0].Length);
713
for (long i = 0; i < dataFrame.
Columns
[0].Length; i++)
714
Assert.Equal(i, dataFrame.
Columns
[0][i]);
742
Assert.Equal(6, df.
Columns
.Count);
743
Assert.Equal("CMT", df.
Columns
["vendor_id"][3]);
748
Assert.Equal(6, reducedRows.
Columns
.Count);
749
Assert.Equal("CMT", reducedRows.
Columns
["vendor_id"][2]);
773
Assert.Equal(4, df.
Columns
.Count);
775
Assert.True(typeof(string) == df.
Columns
[0].DataType);
776
Assert.True(typeof(string) == df.
Columns
[1].DataType);
777
Assert.True(typeof(string) == df.
Columns
[2].DataType);
778
Assert.True(typeof(string) == df.
Columns
[3].DataType);
780
Assert.Equal("vendor_id", df.
Columns
[0].Name);
781
Assert.Equal("rate_code", df.
Columns
[1].Name);
782
Assert.Equal("passenger_count", df.
Columns
[2].Name);
783
Assert.Equal("trip_time_in_secs", df.
Columns
[3].Name);
786
foreach (var column in df.
Columns
)
816
Assert.Equal(4, df.
Columns
.Count);
818
Assert.True(typeof(string) == df.
Columns
[0].DataType);
819
Assert.True(typeof(short) == df.
Columns
[1].DataType);
820
Assert.True(typeof(int) == df.
Columns
[2].DataType);
821
Assert.True(typeof(long) == df.
Columns
[3].DataType);
823
Assert.Equal("vendor_id", df.
Columns
[0].Name);
824
Assert.Equal("rate_code", df.
Columns
[1].Name);
825
Assert.Equal("passenger_count", df.
Columns
[2].Name);
826
Assert.Equal("trip_time_in_secs", df.
Columns
[3].Name);
829
foreach (var column in df.
Columns
)
878
Assert.Equal(4, df.
Columns
.Count);
880
Assert.True(typeof(string) == df.
Columns
[0].DataType);
881
Assert.True(typeof(float) == df.
Columns
[1].DataType);
882
Assert.True(typeof(float) == df.
Columns
[2].DataType);
883
Assert.True(typeof(float) == df.
Columns
[3].DataType);
885
Assert.Equal("vendor_id", df.
Columns
[0].Name);
886
Assert.Equal("rate_code", df.
Columns
[1].Name);
887
Assert.Equal("passenger_count", df.
Columns
[2].Name);
888
Assert.Equal("trip_time_in_secs", df.
Columns
[3].Name);
891
foreach (var column in df.
Columns
)
947
Assert.Equal(dataFrame.
Columns
.Count, readIn.
Columns
.Count);
949
Assert.Equal(typeof(string), readIn.
Columns
[0].DataType);
967
Assert.Equal(dataFrame.
Columns
.Count, readIn.
Columns
.Count);
998
Assert.Equal(dataFrame.
Columns
.Count, readIn.
Columns
.Count);
1031
Assert.Equal(dataFrame.
Columns
.Count, readIn.
Columns
.Count);
1069
Assert.Equal(dataFrame.
Columns
.Count, readIn.
Columns
.Count);
1096
Assert.Equal(dataFrame.
Columns
.Count, readIn.
Columns
.Count);
1123
Assert.Equal(2, df.
Columns
.Count);
1125
Assert.True(typeof(string) == df.
Columns
[0].DataType);
1126
Assert.True(typeof(string) == df.
Columns
[1].DataType);
1128
Assert.Equal("vendor_id", df.
Columns
[0].Name);
1129
Assert.Equal("empty", df.
Columns
[1].Name);
1131
Assert.Equal(2, df.
Columns
[0].NullCount);
1132
Assert.Equal(0, df.
Columns
[1].NullCount);
1143
StringDataFrameColumn emptyColumn = (StringDataFrameColumn)df.
Columns
[1];
1203
var resColumns = dataFrame.
Columns
.Select(column => (column.Name, column.DataType)).ToArray();
1284
Assert.Equal(_columnCount, df.
Columns
.Count);
1288
Assert.True(_columnTypes[j] == df.
Columns
[j].DataType);
1289
Assert.Equal(_columnNames[j], df.
Columns
[j].Name);
DataFrameGroupByTests.cs (5)
68
int numberColumnsCount = df.
Columns
.Count - 2; //except "Parity" and "Tens" columns
109
df.
Columns
.Insert(df.
Columns
.Count, parityColumn);
110
df.
Columns
.Insert(df.
Columns
.Count, tensColumn);
DataFrameIDataViewTests.cs (42)
106
df.
Columns
.Remove("Bool");
111
df.
Columns
.Insert(0, boolColumn);
118
df.
Columns
[1] = boolClone;
254
df.
Columns
.Remove("Char"); // Because chars are returned as uint16 by IDataView, so end up comparing CharDataFrameColumn to UInt16DataFrameColumn and fail asserts
258
Assert.Equal(dfAsIDataView.Schema.Count, newDf.
Columns
.Count);
259
for (int i = 0; i < df.
Columns
.Count; i++)
261
Assert.True(df.
Columns
[i].ElementwiseEquals(newDf.
Columns
[i]).All());
272
Assert.Equal(2, newDf.
Columns
.Count);
273
Assert.True(df.
Columns
["Int"].ElementwiseEquals(newDf.
Columns
["Int"]).All());
274
Assert.True(df.
Columns
["Double"].ElementwiseEquals(newDf.
Columns
["Double"]).All());
284
df.
Columns
.Remove("Char"); // Because chars are returned as uint16 by DataViewSchema, so end up comparing CharDataFrameColumn to UInt16DataFrameColumn and fail asserts
285
df.
Columns
.Remove("Decimal"); // Because decimal is returned as double by DataViewSchema, so end up comparing DecimalDataFrameColumn to DoubleDataFrameColumn and fail asserts
302
Assert.Equal(df.
Columns
.Count, newDf.
Columns
.Count);
303
for (int i = 0; i < newDf.
Columns
.Count; i++)
305
Assert.Equal(rowSize, newDf.
Columns
[i].Length);
306
Assert.Equal(df.
Columns
[i].Name, newDf.
Columns
[i].Name);
308
Assert.Equal(dfAsIDataView.Schema.Count, newDf.
Columns
.Count);
309
for (int c = 0; c < df.
Columns
.Count; c++)
313
Assert.Equal(df.
Columns
[c][r], newDf.
Columns
[c][r]);
325
for (int i = 0; i < newDf.
Columns
.Count; i++)
327
Assert.Equal(5, newDf.
Columns
[i].Length);
329
Assert.Equal(2, newDf.
Columns
.Count);
332
Assert.Equal(df.
Columns
["Int"][r], newDf.
Columns
["Int"][r]);
333
Assert.Equal(df.
Columns
["Double"][r], newDf.
Columns
["Double"][r]);
373
Assert.Equal(value, df.
Columns
[columnName][cc++]);
383
Assert.Equal(3, df.
Columns
.Count);
384
foreach (var column in df.
Columns
)
400
Assert.Equal(2, df.
Columns
.Count);
401
foreach (var column in df.
Columns
)
418
Assert.Equal(3, df.
Columns
.Count);
419
foreach (var column in df.
Columns
)
435
Assert.Equal(2, df.
Columns
.Count);
436
foreach (var column in df.
Columns
)
485
Assert.Equal(12, df.
Columns
.Count);
DataFrameTests.BinaryOperations.cs (63)
96
for (int i = 0; i < df1.
Columns
.Count; i++)
98
newColumn = df1.
Columns
[df1.
Columns
[i].Name] + df2.
Columns
[df2.
Columns
[i].Name];
99
verify = newColumn.ElementwiseEquals(df1.
Columns
[i] * 2);
102
newColumn = df1.
Columns
[df1.
Columns
[i].Name] - df2.
Columns
[df2.
Columns
[i].Name];
106
newColumn = df1.
Columns
[df1.
Columns
[i].Name] * df2.
Columns
[df2.
Columns
[i].Name];
107
verify = newColumn.ElementwiseEquals(df1.
Columns
[i] * df1.
Columns
[i]);
110
var df1Column = df1.
Columns
[i] + 1;
111
var df2Column = df2.
Columns
[i] + 1;
120
verify = df1.
Columns
[df1.
Columns
[i].Name].ElementwiseEquals(df2.
Columns
[df2.
Columns
[i].Name]);
123
verify = df1.
Columns
[df1.
Columns
[i].Name].ElementwiseNotEquals(df2.
Columns
[df2.
Columns
[i].Name]);
126
verify = df1.
Columns
[df1.
Columns
[i].Name].ElementwiseGreaterThanOrEqual(df2.
Columns
[df2.
Columns
[i].Name]);
129
verify = df1.
Columns
[df1.
Columns
[i].Name].ElementwiseLessThanOrEqual(df2.
Columns
[df2.
Columns
[i].Name]);
132
verify = df1.
Columns
[df1.
Columns
[i].Name].ElementwiseGreaterThan(df2.
Columns
[df2.
Columns
[i].Name]);
135
verify = df1.
Columns
[df1.
Columns
[i].Name].ElementwiseLessThan(df2.
Columns
[df2.
Columns
[i].Name]);
147
var dtype = dfd.
Columns
[0].DataType;
152
dtype = dfm.
Columns
[0].DataType;
159
df.
Columns
[0] = dataFrameColumn1;
170
df.
Columns
.Insert(0, dataFrameColumn1);
171
df.
Columns
.Insert(1, dataFrameColumn2);
204
df.
Columns
.Insert(0, dataFrameColumn1);
205
df.
Columns
.Insert(1, dataFrameColumn2);
250
df.
Columns
.Insert(0, stringColumn);
299
df.
Columns
.Insert(0, stringColumn);
363
Assert.True(typeof(decimal) == tempDf.
Columns
["Int"].DataType);
369
Assert.True(typeof(decimal) == tempDf.
Columns
["Int"].DataType);
375
Assert.True(typeof(decimal) == tempDf.
Columns
["Int"].DataType);
381
Assert.True(typeof(decimal) == tempDf.
Columns
["Int"].DataType);
387
Assert.True(typeof(decimal) == tempDf.
Columns
["Int"].DataType);
395
Assert.True(typeof(decimal) == tempDf.
Columns
["Int"].DataType);
401
Assert.True(typeof(decimal) == tempDf.
Columns
["Int"].DataType);
407
Assert.True(typeof(decimal) == tempDf.
Columns
["Int"].DataType);
416
Assert.True(typeof(decimal) == tempDf.
Columns
["Int"].DataType);
422
Assert.True(typeof(decimal) == tempDf.
Columns
["Int"].DataType);
442
Int32DataFrameColumn ints = df.
Columns
["Int"] as Int32DataFrameColumn;
468
BooleanDataFrameColumn bools = df.
Columns
["Bool"] as BooleanDataFrameColumn;
DataFrameTests.Computations.cs (145)
21
Assert.Equal(-10, df.
Columns
["Int"][0]);
23
DataFrameColumn absColumn = df.
Columns
["Int"].Abs();
25
Assert.Equal(-10, df.
Columns
["Int"][0]);
26
df.
Columns
["Int"].Abs(true);
27
Assert.Equal(10, df.
Columns
["Int"][0]);
29
Assert.Throws<NotSupportedException>(() => df.
Columns
["Byte"].All());
30
Assert.Throws<NotSupportedException>(() => df.
Columns
["Byte"].Any());
31
Assert.Throws<NotSupportedException>(() => df.
Columns
["Char"].All());
32
Assert.Throws<NotSupportedException>(() => df.
Columns
["Char"].Any());
33
Assert.Throws<NotSupportedException>(() => df.
Columns
["DateTime"].All());
34
Assert.Throws<NotSupportedException>(() => df.
Columns
["DateTime"].Any());
35
Assert.Throws<NotSupportedException>(() => df.
Columns
["Decimal"].All());
36
Assert.Throws<NotSupportedException>(() => df.
Columns
["Decimal"].Any());
37
Assert.Throws<NotSupportedException>(() => df.
Columns
["Double"].All());
38
Assert.Throws<NotSupportedException>(() => df.
Columns
["Double"].Any());
39
Assert.Throws<NotSupportedException>(() => df.
Columns
["Float"].All());
40
Assert.Throws<NotSupportedException>(() => df.
Columns
["Float"].Any());
41
Assert.Throws<NotSupportedException>(() => df.
Columns
["Int"].All());
42
Assert.Throws<NotSupportedException>(() => df.
Columns
["Int"].Any());
43
Assert.Throws<NotSupportedException>(() => df.
Columns
["Long"].All());
44
Assert.Throws<NotSupportedException>(() => df.
Columns
["Long"].Any());
45
Assert.Throws<NotSupportedException>(() => df.
Columns
["Sbyte"].All());
46
Assert.Throws<NotSupportedException>(() => df.
Columns
["Sbyte"].Any());
47
Assert.Throws<NotSupportedException>(() => df.
Columns
["Short"].All());
48
Assert.Throws<NotSupportedException>(() => df.
Columns
["Short"].Any());
49
Assert.Throws<NotSupportedException>(() => df.
Columns
["Uint"].All());
50
Assert.Throws<NotSupportedException>(() => df.
Columns
["Uint"].Any());
51
Assert.Throws<NotSupportedException>(() => df.
Columns
["Ulong"].All());
52
Assert.Throws<NotSupportedException>(() => df.
Columns
["Ulong"].Any());
53
Assert.Throws<NotSupportedException>(() => df.
Columns
["Ushort"].All());
54
Assert.Throws<NotSupportedException>(() => df.
Columns
["Ushort"].Any());
56
bool any = df.
Columns
["Bool"].Any();
57
bool all = df.
Columns
["Bool"].All();
62
df.
Columns
["Double"][0] = 100.0;
63
DataFrameColumn doubleColumn = df.
Columns
["Double"].CumulativeMax();
71
Assert.Equal(1.0, df.
Columns
["Double"][1]);
72
df.
Columns
["Double"].CumulativeMax(true);
73
for (int i = 0; i < df.
Columns
["Double"].Length; i++)
76
Assert.Null(df.
Columns
["Double"][i]);
78
Assert.Equal(100.0, (double)df.
Columns
["Double"][i]);
81
df.
Columns
["Float"][0] = -10.0f;
82
DataFrameColumn floatColumn = df.
Columns
["Float"].CumulativeMin();
90
Assert.Equal(9.0f, df.
Columns
["Float"][9]);
91
df.
Columns
["Float"].CumulativeMin(true);
92
for (int i = 0; i < df.
Columns
["Float"].Length; i++)
95
Assert.Null(df.
Columns
["Float"][i]);
97
Assert.Equal(-10.0f, (float)df.
Columns
["Float"][i]);
100
DataFrameColumn uintColumn = df.
Columns
["Uint"].CumulativeProduct();
102
Assert.Equal((uint)8, df.
Columns
["Uint"][8]);
103
df.
Columns
["Uint"].CumulativeProduct(true);
104
Assert.Equal((uint)0, df.
Columns
["Uint"][9]);
106
DataFrameColumn ushortColumn = df.
Columns
["Ushort"].CumulativeSum();
108
Assert.Equal((ushort)9, df.
Columns
["Ushort"][9]);
109
df.
Columns
["Ushort"].CumulativeSum(true);
110
Assert.Equal((ushort)40, df.
Columns
["Ushort"][9]);
112
Assert.Equal(100.0, df.
Columns
["Double"].Max());
113
Assert.Equal(-10.0f, df.
Columns
["Float"].Min());
114
Assert.Equal((uint)0, df.
Columns
["Uint"].Product());
115
Assert.Equal((ushort)130, df.
Columns
["Ushort"].Sum());
117
df.
Columns
["Double"][0] = 100.1;
118
Assert.Equal(100.1, df.
Columns
["Double"][0]);
119
DataFrameColumn roundColumn = df.
Columns
["Double"].Round();
121
Assert.Equal(100.1, df.
Columns
["Double"][0]);
122
df.
Columns
["Double"].Round(true);
123
Assert.Equal(100.0, df.
Columns
["Double"][0]);
126
for (int i = 0; i < df.
Columns
.Count; i++)
128
DataFrameColumn column = df.
Columns
[i];
183
Assert.Equal(-10, df.
Columns
["Int"][0]);
185
DataFrameColumn absColumn = df.
Columns
["Int"].Abs();
187
Assert.Equal(-10, df.
Columns
["Int"][0]);
188
df.
Columns
["Int"].Abs(true);
189
Assert.Equal(10, df.
Columns
["Int"][0]);
191
Assert.Throws<NotSupportedException>(() => df.
Columns
["Byte"].All());
192
Assert.Throws<NotSupportedException>(() => df.
Columns
["Byte"].Any());
193
Assert.Throws<NotSupportedException>(() => df.
Columns
["Char"].All());
194
Assert.Throws<NotSupportedException>(() => df.
Columns
["Char"].Any());
195
Assert.Throws<NotSupportedException>(() => df.
Columns
["Decimal"].All());
196
Assert.Throws<NotSupportedException>(() => df.
Columns
["Decimal"].Any());
197
Assert.Throws<NotSupportedException>(() => df.
Columns
["Double"].All());
198
Assert.Throws<NotSupportedException>(() => df.
Columns
["Double"].Any());
199
Assert.Throws<NotSupportedException>(() => df.
Columns
["Float"].All());
200
Assert.Throws<NotSupportedException>(() => df.
Columns
["Float"].Any());
201
Assert.Throws<NotSupportedException>(() => df.
Columns
["Int"].All());
202
Assert.Throws<NotSupportedException>(() => df.
Columns
["Int"].Any());
203
Assert.Throws<NotSupportedException>(() => df.
Columns
["Long"].All());
204
Assert.Throws<NotSupportedException>(() => df.
Columns
["Long"].Any());
205
Assert.Throws<NotSupportedException>(() => df.
Columns
["Sbyte"].All());
206
Assert.Throws<NotSupportedException>(() => df.
Columns
["Sbyte"].Any());
207
Assert.Throws<NotSupportedException>(() => df.
Columns
["Short"].All());
208
Assert.Throws<NotSupportedException>(() => df.
Columns
["Short"].Any());
209
Assert.Throws<NotSupportedException>(() => df.
Columns
["Uint"].All());
210
Assert.Throws<NotSupportedException>(() => df.
Columns
["Uint"].Any());
211
Assert.Throws<NotSupportedException>(() => df.
Columns
["Ulong"].All());
212
Assert.Throws<NotSupportedException>(() => df.
Columns
["Ulong"].Any());
213
Assert.Throws<NotSupportedException>(() => df.
Columns
["Ushort"].All());
214
Assert.Throws<NotSupportedException>(() => df.
Columns
["Ushort"].Any());
215
Assert.Throws<NotSupportedException>(() => df.
Columns
["DateTime"].All());
216
Assert.Throws<NotSupportedException>(() => df.
Columns
["DateTime"].Any());
220
df.
Columns
["DateTime"][0] = maxDate;
221
DataFrameColumn dateTimeColumn = df.
Columns
["DateTime"].CumulativeMax();
231
df.
Columns
["Double"][0] = 100.0;
232
DataFrameColumn doubleColumn = df.
Columns
["Double"].CumulativeMax();
240
Assert.Equal(1.0, df.
Columns
["Double"][1]);
241
df.
Columns
["Double"].CumulativeMax(true);
242
for (int i = 0; i < df.
Columns
["Double"].Length; i++)
245
Assert.Null(df.
Columns
["Double"][i]);
247
Assert.Equal(100.0, (double)df.
Columns
["Double"][i]);
250
df.
Columns
["Float"][0] = -10.0f;
251
DataFrameColumn floatColumn = df.
Columns
["Float"].CumulativeMin();
259
Assert.Equal(9.0f, df.
Columns
["Float"][9]);
260
df.
Columns
["Float"].CumulativeMin(true);
261
for (int i = 0; i < df.
Columns
["Float"].Length; i++)
264
Assert.Null(df.
Columns
["Float"][i]);
266
Assert.Equal(-10.0f, (float)df.
Columns
["Float"][i]);
269
DataFrameColumn uintColumn = df.
Columns
["Uint"].CumulativeProduct();
271
Assert.Equal((uint)8, df.
Columns
["Uint"][8]);
272
df.
Columns
["Uint"].CumulativeProduct(true);
273
Assert.Equal((uint)0, df.
Columns
["Uint"][9]);
275
DataFrameColumn ushortColumn = df.
Columns
["Ushort"].CumulativeSum();
277
Assert.Equal((ushort)9, df.
Columns
["Ushort"][9]);
278
df.
Columns
["Ushort"].CumulativeSum(true);
279
Assert.Equal((ushort)40, df.
Columns
["Ushort"][9]);
281
Assert.Equal(100.0, df.
Columns
["Double"].Max());
282
Assert.Equal(-10.0f, df.
Columns
["Float"].Min());
283
Assert.Equal((uint)0, df.
Columns
["Uint"].Product());
284
Assert.Equal((ushort)130, df.
Columns
["Ushort"].Sum());
286
df.
Columns
["Double"][0] = 100.1;
287
Assert.Equal(100.1, df.
Columns
["Double"][0]);
288
DataFrameColumn roundColumn = df.
Columns
["Double"].Round();
290
Assert.Equal(100.1, df.
Columns
["Double"][0]);
291
df.
Columns
["Double"].Round(true);
292
Assert.Equal(100.0, df.
Columns
["Double"][0]);
295
for (int i = 0; i < df.
Columns
.Count; i++)
297
DataFrameColumn column = df.
Columns
[i];
422
var byteColumn = (PrimitiveDataFrameColumn<byte>)df.
Columns
["Byte"];
423
var decimalColumn = (PrimitiveDataFrameColumn<decimal>)df.
Columns
["Decimal"];
424
var doubleColumn = (PrimitiveDataFrameColumn<double>)df.
Columns
["Double"];
425
var floatColumn = (PrimitiveDataFrameColumn<float>)df.
Columns
["Float"];
426
var intColumn = (PrimitiveDataFrameColumn<int>)df.
Columns
["Int"];
427
var longColumn = (PrimitiveDataFrameColumn<long>)df.
Columns
["Long"];
428
var sbyteColumn = (PrimitiveDataFrameColumn<sbyte>)df.
Columns
["Sbyte"];
429
var shortColumn = (PrimitiveDataFrameColumn<short>)df.
Columns
["Short"];
430
var uintColumn = (PrimitiveDataFrameColumn<uint>)df.
Columns
["Uint"];
431
var ulongColumn = (PrimitiveDataFrameColumn<ulong>)df.
Columns
["Ulong"];
432
var ushortColumn = (PrimitiveDataFrameColumn<ushort>)df.
Columns
["Ushort"];
DataFrameTests.cs (308)
24
Assert.Equal(2, dataFrame.
Columns
.Count);
25
Assert.Equal("Int1", dataFrame.
Columns
[0].Name);
52
df.
Columns
.Insert(0, dc0);
53
var dc = df.
Columns
["a1"];
64
dataFrame.
Columns
.Insert(0, intColumn);
65
dataFrame.
Columns
.Insert(1, floatColumn);
67
Assert.Equal(2, dataFrame.
Columns
.Count);
68
Assert.Equal(2, dataFrame.
Columns
.LongCount());
69
Assert.Equal(rowCount, dataFrame.
Columns
[0].Length);
70
Assert.Equal("IntColumn", dataFrame.
Columns
[0].Name);
71
Assert.Equal(rowCount, dataFrame.
Columns
[1].Length);
72
Assert.Equal("FloatColumn", dataFrame.
Columns
[1].Name);
76
Assert.Throws<ArgumentException>(() => dataFrame.
Columns
.Insert(2, bigColumn));
77
Assert.Throws<ArgumentException>(() => dataFrame.
Columns
.Add(bigColumn));
81
Assert.Throws<ArgumentException>(() => dataFrame.
Columns
.Insert(2, smallColumn));
82
Assert.Throws<ArgumentException>(() => dataFrame.
Columns
.Add(smallColumn));
86
Assert.Throws<ArgumentException>(() => dataFrame.
Columns
.Insert(2, repeatedName));
90
var columnCount = dataFrame.
Columns
.Count;
91
Assert.Throws<ArgumentOutOfRangeException>(() => dataFrame.
Columns
.Insert(columnCount + 1, repeatedName));
93
Assert.Equal(2, dataFrame.
Columns
.Count);
95
Assert.Throws<ArgumentException>(() => dataFrame.
Columns
[1] = intColumnCopy);
98
dataFrame.
Columns
[1] = differentIntColumn;
99
Assert.True(object.ReferenceEquals(differentIntColumn, dataFrame.
Columns
[1]));
101
dataFrame.
Columns
.RemoveAt(1);
102
Assert.Single(dataFrame.
Columns
);
103
Assert.True(ReferenceEquals(intColumn, dataFrame.
Columns
[0]));
107
Assert.Equal(2, dataFrame1.
Columns
.Count);
108
Assert.Equal(intColumn, dataFrame1.
Columns
[0]);
109
Assert.Equal(floatColumn, dataFrame1.
Columns
[1]);
118
int columnCount = dataFrame.
Columns
.Count;
119
DataFrameColumn originalLastColumn = dataFrame.
Columns
[columnCount - 1];
122
dataFrame.
Columns
.Insert(columnCount, intColumn);
123
Assert.Equal(columnCount + 1, dataFrame.
Columns
.Count);
126
dataFrame.
Columns
.RemoveAt(0);
127
Assert.Equal(columnCount, dataFrame.
Columns
.Count);
130
DataFrameColumn intColumn_1 = dataFrame.
Columns
["NewIntColumn"];
134
DataFrameColumn lastColumn_1 = dataFrame.
Columns
[originalLastColumn.Name];
138
int newIndex = dataFrame.
Columns
.IndexOf("NewIntColumn");
142
int newIndexForOriginalLastColumn = dataFrame.
Columns
.IndexOf(originalLastColumn.Name);
152
dataFrame.
Columns
.Add(intColumn);
153
Assert.Single(dataFrame.
Columns
);
156
dataFrame.
Columns
.Remove(intColumn);
157
Assert.Empty(dataFrame.
Columns
);
168
dataFrame.
Columns
.Clear();
171
Assert.Empty(dataFrame.
Columns
);
174
Assert.Equal(0, dataFrame.
Columns
.LongCount());
205
dataframe.
Columns
.RenameColumn("City", "Town");
229
df["Int3"] = df.
Columns
["Int1"] * 2 + df.
Columns
["Int2"];
230
Assert.Equal(16, df.
Columns
["Int3"][2]);
237
df.
Columns
["Int"][0] = 100;
238
df.
Columns
["Int"][19] = -1;
239
df.
Columns
["Int"][5] = 2000;
243
Assert.Null(sortedDf.
Columns
["Int"][19]);
244
Assert.Equal(-1, sortedDf.
Columns
["Int"][0]);
245
Assert.Equal(100, sortedDf.
Columns
["Int"][17]);
246
Assert.Equal(2000, sortedDf.
Columns
["Int"][18]);
250
Assert.Null(sortedDf.
Columns
["Int"][19]);
251
Assert.Equal(-1, sortedDf.
Columns
["Int"][18]);
252
Assert.Equal(100, sortedDf.
Columns
["Int"][1]);
253
Assert.Equal(2000, sortedDf.
Columns
["Int"][0]);
257
Assert.Null(sortedDf.
Columns
["Int"][0]);
258
Assert.Equal(-1, sortedDf.
Columns
["Int"][1]);
259
Assert.Equal(100, sortedDf.
Columns
["Int"][18]);
260
Assert.Equal(2000, sortedDf.
Columns
["Int"][19]);
264
Assert.Null(sortedDf.
Columns
["Int"][0]);
265
Assert.Equal(-1, sortedDf.
Columns
["Int"][19]);
266
Assert.Equal(100, sortedDf.
Columns
["Int"][2]);
267
Assert.Equal(2000, sortedDf.
Columns
["Int"][1]);
271
Assert.Null(sortedDf.
Columns
["Int"][19]);
272
Assert.Equal(1, sortedDf.
Columns
["Int"][1]);
273
Assert.Equal(8, sortedDf.
Columns
["Int"][17]);
274
Assert.Equal(9, sortedDf.
Columns
["Int"][18]);
278
Assert.Null(sortedDf.
Columns
["Int"][19]);
279
Assert.Equal(8, sortedDf.
Columns
["Int"][1]);
280
Assert.Equal(9, sortedDf.
Columns
["Int"][0]);
284
Assert.Null(sortedDf.
Columns
["Int"][0]);
285
Assert.Equal(1, sortedDf.
Columns
["Int"][2]);
286
Assert.Equal(8, sortedDf.
Columns
["Int"][18]);
287
Assert.Equal(9, sortedDf.
Columns
["Int"][19]);
291
Assert.Null(sortedDf.
Columns
["Int"][0]);
292
Assert.Equal(8, sortedDf.
Columns
["Int"][2]);
293
Assert.Equal(9, sortedDf.
Columns
["Int"][1]);
302
Assert.Equal((long)5, count.
Columns
["Int"][0]);
303
Assert.Equal((long)4, count.
Columns
["Decimal"][1]);
306
for (int c = 1; c < count.
Columns
.Count; c++)
308
Assert.Equal((long)(r == 0 ? 5 : 4), count.
Columns
[c][r]);
316
for (int c = 0; c < count.
Columns
.Count; c++)
318
DataFrameColumn originalColumn = df.
Columns
[c];
319
DataFrameColumn firstColumn = first.
Columns
[originalColumn.Name];
328
for (int c = 0; c < count.
Columns
.Count; c++)
330
DataFrameColumn originalColumn = df.
Columns
[c];
331
DataFrameColumn headColumn = head.
Columns
[originalColumn.Name];
335
for (int c = 0; c < count.
Columns
.Count; c++)
337
DataFrameColumn originalColumn = df.
Columns
[c];
340
DataFrameColumn headColumn = head.
Columns
[originalColumn.Name];
351
for (int c = 0; c < count.
Columns
.Count; c++)
353
DataFrameColumn originalColumn = df.
Columns
[c];
354
DataFrameColumn tailColumn = tail.
Columns
[originalColumn.Name];
363
for (int c = 0; c < count.
Columns
.Count; c++)
365
DataFrameColumn originalColumn = df.
Columns
[c];
368
DataFrameColumn maxColumn = max.
Columns
[originalColumn.Name];
386
for (int c = 0; c < count.
Columns
.Count; c++)
388
DataFrameColumn originalColumn = df.
Columns
[c];
391
DataFrameColumn minColumn = min.
Columns
[originalColumn.Name];
394
DataFrameColumn productColumn = product.
Columns
[originalColumn.Name];
397
DataFrameColumn sumColumn = sum.
Columns
[originalColumn.Name];
403
Assert.Equal(2, columnSum.
Columns
.Count);
404
Assert.Equal(20, columnSum.
Columns
["Int"][0]);
405
Assert.Equal(20, columnSum.
Columns
["Int"][1]);
407
Assert.Equal(2, columnMax.
Columns
.Count);
408
Assert.Equal(8, columnMax.
Columns
["Int"][0]);
409
Assert.Equal(9, columnMax.
Columns
["Int"][1]);
411
Assert.Equal(2, columnProduct.
Columns
.Count);
412
Assert.Equal(0, columnProduct.
Columns
["Int"][0]);
413
Assert.Equal(0, columnProduct.
Columns
["Int"][1]);
415
Assert.Equal(2, columnMin.
Columns
.Count);
416
Assert.Equal(0, columnMin.
Columns
["Int"][0]);
417
Assert.Equal(1, columnMin.
Columns
["Int"][1]);
420
Assert.Equal(2, countIntColumn.
Columns
.Count);
422
Assert.Equal((long)5, countIntColumn.
Columns
["Int"][0]);
423
Assert.Equal((long)4, countIntColumn.
Columns
["Int"][1]);
426
Assert.Equal(2, firstDecimalColumn.
Columns
.Count);
428
Assert.Equal((decimal)0, firstDecimalColumn.
Columns
["Decimal"][0]);
429
Assert.Equal((decimal)1, firstDecimalColumn.
Columns
["Decimal"][1]);
484
for (int i = 0; i < df.
Columns
.Count; i++)
486
DataFrameColumn baseColumn = df.
Columns
[i];
492
Assert.Equal(10 * df.
Columns
.Count, totalValueCount);
496
StringDataFrameColumn stringColumn = (StringDataFrameColumn)df.
Columns
["String"];
511
ArrowStringDataFrameColumn arrowStringColumn = (ArrowStringDataFrameColumn)df.
Columns
["ArrowString"];
526
SingleDataFrameColumn floatColumn = (SingleDataFrameColumn)df.
Columns
["Float"];
541
Int32DataFrameColumn intColumn = (Int32DataFrameColumn)df.
Columns
["Int"];
562
DataFrameColumn clamped = df.
Columns
["Int"].Clamp(3, 7);
564
Assert.Equal(0, df.
Columns
["Int"][0]);
566
Assert.Equal(1, df.
Columns
["Int"][1]);
568
Assert.Equal(2, df.
Columns
["Int"][2]);
570
Assert.Equal(3, df.
Columns
["Int"][3]);
572
Assert.Equal(4, df.
Columns
["Int"][4]);
574
Assert.Null(df.
Columns
["Int"][5]);
576
Assert.Equal(6, df.
Columns
["Int"][6]);
578
Assert.Equal(7, df.
Columns
["Int"][7]);
580
Assert.Equal(8, df.
Columns
["Int"][8]);
582
Assert.Equal(9, df.
Columns
["Int"][9]);
585
df.
Columns
["Int"].Clamp(3, 7, true);
586
Assert.Equal(3, df.
Columns
["Int"][0]);
587
Assert.Equal(3, df.
Columns
["Int"][1]);
588
Assert.Equal(3, df.
Columns
["Int"][2]);
589
Assert.Equal(3, df.
Columns
["Int"][3]);
590
Assert.Equal(4, df.
Columns
["Int"][4]);
591
Assert.Null(df.
Columns
["Int"][5]);
592
Assert.Equal(6, df.
Columns
["Int"][6]);
593
Assert.Equal(7, df.
Columns
["Int"][7]);
594
Assert.Equal(7, df.
Columns
["Int"][8]);
595
Assert.Equal(7, df.
Columns
["Int"][9]);
608
Assert.Equal(df.
Columns
.Count, clampedColumn.
Columns
.Count);
610
for (int c = 0; c < df.
Columns
.Count; c++)
612
DataFrameColumn column = clampedColumn.
Columns
[c];
631
var colD = df.
Columns
[c][i];
633
Assert.Equal(df.
Columns
[c][i], column[i]);
645
Assert.Equal(i, df.
Columns
["Int"][i]);
647
Assert.Null(df.
Columns
["Int"][5]);
707
Assert.Equal(df.
Columns
.Count, sampled.
Columns
.Count);
711
foreach (int? value in sampled.
Columns
["Int"])
727
DataFrameColumn descriptionColumn = description.
Columns
[0];
733
for (int i = 1; i < description.
Columns
.Count - 1; i++)
735
DataFrameColumn column = description.
Columns
[i];
736
Assert.Equal(df.
Columns
[i - 1].Name, column.Name);
745
DataFrameColumn dateTimeColumn = description.
Columns
[description.
Columns
.Count - 1];
765
df.
Columns
.Add(dateTimes);
768
DataFrameColumn infoColumn = Info.
Columns
[0];
773
for (int i = 1; i < Info.
Columns
.Count; i++)
775
DataFrameColumn column = Info.
Columns
[i];
776
Assert.Equal(df.
Columns
[i - 1].DataType.ToString(), column[0].ToString());
800
df.
Columns
.Insert(0, dataFrameColumn1);
804
Assert.Throws<ArgumentException>(() => df.
Columns
.Insert(1, new Int32DataFrameColumn("Int2", Enumerable.Range(0, 5).Select(x => x))));
859
DataFrame valueCounts = df.
Columns
["Bool"].ValueCounts();
861
Assert.Equal((long)5, valueCounts.
Columns
["Counts"][0]);
862
Assert.Equal((long)5, valueCounts.
Columns
["Counts"][1]);
870
Int32DataFrameColumn column = df.
Columns
["Int1"] as Int32DataFrameColumn;
915
Int32DataFrameColumn intColumn = intDf.
Columns
["Int1"] as Int32DataFrameColumn;
918
Assert.Equal(df.
Columns
.Count, clone.
Columns
.Count);
919
for (int i = 0; i < df.
Columns
.Count; i++)
921
DataFrameColumn dfColumn = df.
Columns
[i];
922
DataFrameColumn cloneColumn = clone.
Columns
[i];
934
BooleanDataFrameColumn bigInts = new BooleanDataFrameColumn("BigInts", df.
Columns
["Int"].ElementwiseGreaterThan(5));
948
IReadOnlyList<DataFrameColumn> columns = df.
Columns
;
950
Assert.Equal(columns.Count, df.
Columns
.Count);
953
Assert.Equal(dataFrameColumn, df.
Columns
[i++]);
973
Assert.Equal(df.
Columns
[columnIndex][rowCount], value);
981
int intColumnIndex = df.
Columns
.IndexOf("Int");
982
Assert.Equal(1, df.
Columns
[intColumnIndex].NullCount);
984
Assert.Equal(0, df.
Columns
[intColumnIndex].NullCount);
986
Assert.Equal(1, df.
Columns
[intColumnIndex].NullCount);
997
for (int i = 0; i < df.
Columns
.Count; i++)
999
DataFrameColumn column = df.
Columns
[i];
1004
foreach (var column in df.
Columns
)
1019
Assert.Equal(1, df.
Columns
[0].NullCount);
1020
Assert.Equal(1, df.
Columns
[1].NullCount);
1024
Assert.Equal(1, df.
Columns
[0].NullCount);
1025
Assert.Equal(1, df.
Columns
[1].NullCount);
1032
Assert.Equal(2, ret.
Columns
[0].NullCount);
1033
Assert.Equal(2, ret.
Columns
[1].NullCount);
1037
for (int j = 0; j < check1.
Columns
.Count; j++)
1072
Assert.Equal(3, resultDataFrame.
Columns
.Count);
1091
Assert.Equal(1, df.
Columns
[0].NullCount);
1092
Assert.Equal(1, df.
Columns
[1].NullCount);
1096
Assert.Equal(1, ret.
Columns
[0].NullCount);
1097
Assert.Equal(1, ret.
Columns
[1].NullCount);
1101
Assert.Equal(1, df.
Columns
[0].NullCount);
1102
Assert.Equal(2, df.
Columns
[1].NullCount);
1106
Assert.Equal(1, ret.
Columns
[0].NullCount);
1107
Assert.Equal(3, ret.
Columns
[1].NullCount);
1111
Assert.Equal(2, df.
Columns
[0].NullCount);
1112
Assert.Equal(3, df.
Columns
[1].NullCount);
1115
Assert.Equal(3, ret.
Columns
[0].NullCount);
1116
Assert.Equal(4, ret.
Columns
[1].NullCount);
1120
Assert.Equal(2, df.
Columns
[0].NullCount);
1121
Assert.Equal(3, df.
Columns
[1].NullCount);
1124
Assert.Equal(2, ret.
Columns
[0].NullCount);
1125
Assert.Equal(3, ret.
Columns
[1].NullCount);
1130
Assert.Equal(15, df.
Columns
["Column1"].Length);
1131
Assert.Equal(15, df.
Columns
["Column2"].Length);
1132
Assert.Equal(2, df.
Columns
[0].NullCount);
1133
Assert.Equal(4, df.
Columns
[1].NullCount);
1137
Assert.Equal(16, ret.
Columns
["Column1"].Length);
1138
Assert.Equal(16, ret.
Columns
["Column2"].Length);
1139
Assert.Equal(2, ret.
Columns
[0].NullCount);
1140
Assert.Equal(5, ret.
Columns
[1].NullCount);
1144
Assert.Equal(16, df.
Columns
["Column1"].Length);
1145
Assert.Equal(16, df.
Columns
["Column2"].Length);
1146
Assert.Equal(3, df.
Columns
[0].NullCount);
1147
Assert.Equal(4, df.
Columns
[1].NullCount);
1150
Assert.Equal(17, ret.
Columns
["Column1"].Length);
1151
Assert.Equal(17, ret.
Columns
["Column2"].Length);
1152
Assert.Equal(4, ret.
Columns
[0].NullCount);
1153
Assert.Equal(4, ret.
Columns
[1].NullCount);
1157
Assert.Equal(17, df.
Columns
["Column1"].Length);
1158
Assert.Equal(17, df.
Columns
["Column2"].Length);
1159
Assert.Equal(4, df.
Columns
[0].NullCount);
1160
Assert.Equal(5, df.
Columns
[1].NullCount);
1163
Assert.Equal(18, ret.
Columns
["Column1"].Length);
1164
Assert.Equal(18, ret.
Columns
["Column2"].Length);
1165
Assert.Equal(5, ret.
Columns
[0].NullCount);
1166
Assert.Equal(6, ret.
Columns
[1].NullCount);
1175
Assert.Equal(18, df.
Columns
["Column1"].Length);
1176
Assert.Equal(18, df.
Columns
["Column2"].Length);
1177
Assert.Equal(5, df.
Columns
[0].NullCount);
1178
Assert.Equal(6, df.
Columns
[1].NullCount);
1182
Assert.Equal(18, df.
Columns
["Column1"].Length);
1183
Assert.Equal(18, df.
Columns
["Column2"].Length);
1184
Assert.Equal(5, df.
Columns
[0].NullCount);
1185
Assert.Equal(6, df.
Columns
[1].NullCount);
1187
Assert.Equal(19, ret.
Columns
["Column1"].Length);
1188
Assert.Equal(19, ret.
Columns
["Column2"].Length);
1189
Assert.Equal(6, ret.
Columns
[0].NullCount);
1190
Assert.Equal(7, ret.
Columns
[1].NullCount);
1199
Assert.Equal(2, df.
Columns
[0].NullCount);
1200
Assert.Equal(1, df.
Columns
[1].NullCount);
1203
df.
Columns
.Add(column);
1207
Assert.Equal(2, df.
Columns
[0].NullCount);
1208
Assert.Equal(1, df.
Columns
[1].NullCount);
1209
Assert.Equal(0, df.
Columns
[2].NullCount);
1213
Assert.Equal(1, df.
Columns
[2].NullCount);
1278
PrimitiveDataFrameColumn<int> primitiveInts = dataFrame.
Columns
.GetPrimitiveColumn<int>("Int");
1280
Assert.Throws<ArgumentException>(() => dataFrame.
Columns
.GetPrimitiveColumn<float>("Int"));
1282
StringDataFrameColumn strings = dataFrame.
Columns
.GetStringColumn("String");
1284
Assert.Throws<ArgumentException>(() => dataFrame.
Columns
.GetStringColumn("ArrowString"));
1286
ArrowStringDataFrameColumn arrowStrings = dataFrame.
Columns
.GetArrowStringColumn("ArrowString");
1288
Assert.Throws<ArgumentException>(() => dataFrame.
Columns
.GetArrowStringColumn("String"));
1290
ByteDataFrameColumn bytes = dataFrame.
Columns
.GetByteColumn("Byte");
1292
Assert.Throws<ArgumentException>(() => dataFrame.
Columns
.GetSingleColumn("Byte"));
1294
Int32DataFrameColumn ints = dataFrame.
Columns
.GetInt32Column("Int");
1296
Assert.Throws<ArgumentException>(() => dataFrame.
Columns
.GetSingleColumn("Int"));
1298
BooleanDataFrameColumn bools = dataFrame.
Columns
.GetBooleanColumn("Bool");
1300
Assert.Throws<ArgumentException>(() => dataFrame.
Columns
.GetSingleColumn("Bool"));
1302
CharDataFrameColumn chars = dataFrame.
Columns
.GetCharColumn("Char");
1304
Assert.Throws<ArgumentException>(() => dataFrame.
Columns
.GetSingleColumn("Char"));
1306
DecimalDataFrameColumn decimals = dataFrame.
Columns
.GetDecimalColumn("Decimal");
1308
Assert.Throws<ArgumentException>(() => dataFrame.
Columns
.GetSingleColumn("Decimal"));
1310
DoubleDataFrameColumn doubles = dataFrame.
Columns
.GetDoubleColumn("Double");
1312
Assert.Throws<ArgumentException>(() => dataFrame.
Columns
.GetSingleColumn("Double"));
1314
SingleDataFrameColumn singles = dataFrame.
Columns
.GetSingleColumn("Float");
1316
Assert.Throws<ArgumentException>(() => dataFrame.
Columns
.GetDoubleColumn("Float"));
1318
Int64DataFrameColumn longs = dataFrame.
Columns
.GetInt64Column("Long");
1320
Assert.Throws<ArgumentException>(() => dataFrame.
Columns
.GetSingleColumn("Long"));
1322
SByteDataFrameColumn sbytes = dataFrame.
Columns
.GetSByteColumn("Sbyte");
1324
Assert.Throws<ArgumentException>(() => dataFrame.
Columns
.GetSingleColumn("Sbyte"));
1326
Int16DataFrameColumn shorts = dataFrame.
Columns
.GetInt16Column("Short");
1328
Assert.Throws<ArgumentException>(() => dataFrame.
Columns
.GetSingleColumn("Short"));
1330
UInt32DataFrameColumn uints = dataFrame.
Columns
.GetUInt32Column("Uint");
1332
Assert.Throws<ArgumentException>(() => dataFrame.
Columns
.GetSingleColumn("Uint"));
1334
UInt64DataFrameColumn ulongs = dataFrame.
Columns
.GetUInt64Column("Ulong");
1336
Assert.Throws<ArgumentException>(() => dataFrame.
Columns
.GetSingleColumn("Ulong"));
1338
UInt16DataFrameColumn ushorts = dataFrame.
Columns
.GetUInt16Column("Ushort");
1340
Assert.Throws<ArgumentException>(() => dataFrame.
Columns
.GetSingleColumn("Ushort"));
1368
Assert.True(filteredNullDf.
Columns
.IndexOf("col") >= 0);
1369
Assert.Equal(3, filteredNullDf.
Columns
["col"].Length);
1371
Assert.Equal("One", filteredNullDf.
Columns
["col"][0]);
1372
Assert.Equal("Two", filteredNullDf.
Columns
["col"][1]);
1373
Assert.Equal("Three", filteredNullDf.
Columns
["col"][2]);
1385
Assert.True(filteredNullDf.
Columns
.IndexOf("col") >= 0);
1386
Assert.True(filteredNullDf.
Columns
.IndexOf("index") >= 0);
1390
Assert.Equal(2, filteredNullDf.
Columns
["index"][0]);
1391
Assert.Equal(5, filteredNullDf.
Columns
["index"][1]);
DataFrameTests.Filter.cs (15)
20
DataFrameColumn filtered = df.
Columns
["Int"].Filter(3, 7);
32
DataFrame boolColumnFiltered = df[df.
Columns
["Bool"].ElementwiseEquals(true)];
35
for (int i = 0; i < boolColumnFiltered.
Columns
.Count; i++)
37
DataFrameColumn column = boolColumnFiltered.
Columns
[i];
48
Assert.Equal(intEnumerableFiltered.
Columns
.Count, df.
Columns
.Count);
49
Assert.Equal(boolEnumerableFiltered.
Columns
.Count, df.
Columns
.Count);
50
Assert.Equal(longEnumerableFiltered.
Columns
.Count, df.
Columns
.Count);
51
for (int i = 0; i < intEnumerableFiltered.
Columns
.Count; i++)
53
DataFrameColumn intFilteredColumn = intEnumerableFiltered.
Columns
[i];
54
DataFrameColumn dfColumn = df.
Columns
[i];
55
DataFrameColumn boolFilteredColumn = boolEnumerableFiltered.
Columns
[i];
56
DataFrameColumn longFilteredColumn = longEnumerableFiltered.
Columns
[i];
DataFrameTests.Join.cs (58)
26
Assert.Equal(join.
Columns
.Count, left.
Columns
.Count + right.
Columns
.Count);
27
Assert.Null(join.
Columns
["Int_right"][6]);
33
Assert.Equal(join.
Columns
.Count, left.
Columns
.Count + right.
Columns
.Count);
34
Assert.Equal(join.
Columns
["Int_right"][3], right.
Columns
["Int"][3]);
35
Assert.Null(join.
Columns
["Int_right"][2]);
41
Assert.Equal(join.
Columns
.Count, left.
Columns
.Count + right.
Columns
.Count);
42
Assert.Null(join.
Columns
["Int_right"][6]);
48
Assert.Equal(join.
Columns
.Count, left.
Columns
.Count + right.
Columns
.Count);
49
Assert.Equal(join.
Columns
["Int_right"][3], right.
Columns
["Int"][3]);
50
Assert.Null(join.
Columns
["Int_right"][2]);
58
Assert.Equal(join.
Columns
.Count, left.
Columns
.Count + right.
Columns
.Count);
59
Assert.Equal(join.
Columns
["Int_right"][6], right.
Columns
["Int"][6]);
65
Assert.Equal(join.
Columns
.Count, left.
Columns
.Count + right.
Columns
.Count);
66
Assert.Equal(join.
Columns
["Int_right"][2], right.
Columns
["Int"][2]);
67
Assert.Null(join.
Columns
["Int_left"][12]);
73
Assert.Equal(join.
Columns
.Count, left.
Columns
.Count + right.
Columns
.Count);
74
Assert.Null(join.
Columns
["Int_left"][12]);
80
Assert.Equal(join.
Columns
.Count, left.
Columns
.Count + right.
Columns
.Count);
81
Assert.Equal(join.
Columns
["Int_right"][2], right.
Columns
["Int"][2]);
92
for (int i = 0; i < join.
Columns
.Count; i++)
94
DataFrameColumn joinColumn = join.
Columns
[i];
99
if (i < left.
Columns
.Count)
101
DataFrameColumn leftColumn = left.
Columns
[i];
106
int columnIndex = i - left.
Columns
.Count;
107
DataFrameColumn rightColumn = right.
Columns
[columnIndex];
114
if (i < left.
Columns
.Count)
116
DataFrameColumn leftColumn = left.
Columns
[i];
122
int columnIndex = i - left.
Columns
.Count;
123
DataFrameColumn rightColumn = right.
Columns
[columnIndex];
129
if (i < left.
Columns
.Count)
131
DataFrameColumn leftColumn = left.
Columns
[i];
136
int columnIndex = i - left.
Columns
.Count;
137
DataFrameColumn rightColumn = right.
Columns
[columnIndex];
143
if (i < left.
Columns
.Count)
145
DataFrameColumn leftColumn = left.
Columns
[i];
150
int columnIndex = i - left.
Columns
.Count;
151
DataFrameColumn rightColumn = right.
Columns
[columnIndex];
DataFrameTests.Merge.cs (171)
23
left.
Columns
.Insert(left.
Columns
.Count, leftStringColumn);
27
right.
Columns
.Insert(right.
Columns
.Count, rightStringColumn);
31
Assert.Equal("Left", (string)merge.
Columns
["String_left"][0]);
32
Assert.Equal("Right", (string)merge.
Columns
["String_right"][0]);
45
Assert.Equal(merge.
Columns
.Count, left.
Columns
.Count + right.
Columns
.Count);
46
Assert.Null(merge.
Columns
["Int_right"][6]);
47
Assert.Null(merge.
Columns
["Int_left"][5]);
53
Assert.Equal(merge.
Columns
.Count, left.
Columns
.Count + right.
Columns
.Count);
54
Assert.Equal(merge.
Columns
["Int_right"][3], right.
Columns
["Int"][3]);
55
Assert.Null(merge.
Columns
["Int_right"][2]);
61
Assert.Equal(merge.
Columns
.Count, left.
Columns
.Count + right.
Columns
.Count);
62
Assert.Null(merge.
Columns
["Int_right"][6]);
68
Assert.Equal(merge.
Columns
.Count, left.
Columns
.Count + right.
Columns
.Count);
69
Assert.Equal(merge.
Columns
["Int_right"][2], right.
Columns
["Int"][3]);
70
Assert.Null(merge.
Columns
["Int_right"][4]);
78
Assert.Equal(merge.
Columns
.Count, left.
Columns
.Count + right.
Columns
.Count);
79
Assert.Equal(merge.
Columns
["Int_right"][6], right.
Columns
["Int"][6]);
85
Assert.Equal(merge.
Columns
.Count, left.
Columns
.Count + right.
Columns
.Count);
86
Assert.Equal(merge.
Columns
["Int_right"][2], right.
Columns
["Int"][2]);
87
Assert.Null(merge.
Columns
["Int_left"][12]);
93
Assert.Equal(merge.
Columns
.Count, left.
Columns
.Count + right.
Columns
.Count);
94
Assert.Null(merge.
Columns
["Int_left"][12]);
95
Assert.Null(merge.
Columns
["Int_left"][15]);
101
Assert.Equal(merge.
Columns
.Count, left.
Columns
.Count + right.
Columns
.Count);
102
Assert.Equal(merge.
Columns
["Int_right"][2], right.
Columns
["Int"][2]);
108
Assert.Equal(merge.
Columns
.Count, left.
Columns
.Count + right.
Columns
.Count);
114
if (columnIndex < left.
Columns
.Count)
123
int rightColumnIndex = columnIndex - left.
Columns
.Count;
152
Assert.Equal(merge.
Columns
.Count, left.
Columns
.Count + right.
Columns
.Count);
210
Assert.Equal(merge.
Columns
.Count, left.
Columns
.Count + right.
Columns
.Count);
260
Assert.Equal(merge.
Columns
.Count, left.
Columns
.Count + right.
Columns
.Count);
299
left.
Columns
.Add(new Int32DataFrameColumn("Index", new[] { 0, 1, 2, 3, 4, 5 }));
300
left.
Columns
.Add(new Int32DataFrameColumn("G1", new[] { 0, 1, 1, 2, 2, 3 }));
301
left.
Columns
.Add(new Int32DataFrameColumn("G2", new[] { 3, 1, 2, 1, 2, 1 }));
304
right.
Columns
.Add(new Int32DataFrameColumn("Index", new[] { 0, 1, 2, 3 }));
305
right.
Columns
.Add(new Int32DataFrameColumn("G1", new[] { 1, 1, 1, 2 }));
306
right.
Columns
.Add(new Int32DataFrameColumn("G2", new[] { 1, 2, 1, 1 }));
349
Assert.Equal(merge.
Columns
.Count, left.
Columns
.Count + right.
Columns
.Count);
365
left.
Columns
.Add(new Int32DataFrameColumn("Index", new[] { 0, 1, 2 }));
366
left.
Columns
.Add(new Int32DataFrameColumn("G1", new[] { 1, 1, 3 }));
367
left.
Columns
.Add(new Int32DataFrameColumn("G2", new[] { 1, 1, 3 }));
370
right.
Columns
.Add(new Int32DataFrameColumn("Index", new[] { 0, 1, 2 }));
371
right.
Columns
.Add(new Int32DataFrameColumn("G1", new[] { 1, 1, 0 }));
372
right.
Columns
.Add(new Int32DataFrameColumn("G2", new[] { 1, 1, 0 }));
408
Assert.Equal(merge.
Columns
.Count, left.
Columns
.Count + right.
Columns
.Count);
423
left.
Columns
.Add(new Int32DataFrameColumn("Index", new[] { 0, 1, 2 }));
424
left.
Columns
.Add(new Int32DataFrameColumn("G1", new[] { 1, 1, 3 }));
425
left.
Columns
.Add(new Int32DataFrameColumn("G2", new[] { 1, 1, 3 }));
428
right.
Columns
.Add(new Int32DataFrameColumn("Index", new[] { 0, 1, 2 }));
429
right.
Columns
.Add(new Int32DataFrameColumn("G1", new[] { 1, 1, 0 }));
430
right.
Columns
.Add(new Int32DataFrameColumn("G2", new[] { 1, 1, 0 }));
466
Assert.Equal(merge.
Columns
.Count, left.
Columns
.Count + right.
Columns
.Count);
481
left.
Columns
.Add(new Int32DataFrameColumn("Index", new[] { 0, 1, 2 }));
482
left.
Columns
.Add(new Int32DataFrameColumn("G1", new[] { 1, 1, 3 }));
483
left.
Columns
.Add(new Int32DataFrameColumn("G2", new[] { 1, 1, 3 }));
486
right.
Columns
.Add(new Int32DataFrameColumn("Index", new[] { 0, 1, 2 }));
487
right.
Columns
.Add(new Int32DataFrameColumn("G1", new[] { 1, 1, 0 }));
488
right.
Columns
.Add(new Int32DataFrameColumn("G2", new[] { 1, 1, 0 }));
522
Assert.Equal(merge.
Columns
.Count, left.
Columns
.Count + right.
Columns
.Count);
537
left.
Columns
.Add(new Int32DataFrameColumn("Index", new[] { 0, 1, 2 }));
538
left.
Columns
.Add(new Int32DataFrameColumn("G1", new[] { 1, 1, 3 }));
539
left.
Columns
.Add(new Int32DataFrameColumn("G2", new[] { 1, 1, 3 }));
542
right.
Columns
.Add(new Int32DataFrameColumn("Index", new[] { 0, 1, 2 }));
543
right.
Columns
.Add(new Int32DataFrameColumn("G1", new[] { 1, 1, 0 }));
544
right.
Columns
.Add(new Int32DataFrameColumn("G2", new[] { 1, 1, 0 }));
582
Assert.Equal(merge.
Columns
.Count, left.
Columns
.Count + right.
Columns
.Count);
597
left.
Columns
.Add(new Int32DataFrameColumn("Index", new[] { 0, 1, 2 }));
598
left.
Columns
.Add(new Int32DataFrameColumn("G1", new[] { 1, 1, 2 }));
599
left.
Columns
.Add(new Int32DataFrameColumn("G2", new[] { 1, 2, 1 }));
600
left.
Columns
.Add(new StringDataFrameColumn("G3", new[] { "A", "B", "C" }));
603
right.
Columns
.Add(new Int32DataFrameColumn("Index", new[] { 0, 1, 2 }));
604
right.
Columns
.Add(new Int32DataFrameColumn("G1", new[] { 0, 1, 1 }));
605
right.
Columns
.Add(new Int32DataFrameColumn("G2", new[] { 1, 1, 2 }));
606
right.
Columns
.Add(new StringDataFrameColumn("G3", new[] { "Z", "Y", "B" }));
638
Assert.Equal(merge.
Columns
.Count, left.
Columns
.Count + right.
Columns
.Count);
653
left.
Columns
.Add(new Int32DataFrameColumn("Index", new[] { 0, 1, 2 }));
654
left.
Columns
.Add(new Int32DataFrameColumn("G1", new[] { 1, 1, 2 }));
655
left.
Columns
.Add(new Int32DataFrameColumn("G2", new[] { 1, 2, 1 }));
656
left.
Columns
.Add(new StringDataFrameColumn("G3", new[] { "A", "B", "C" }));
659
right.
Columns
.Add(new Int32DataFrameColumn("Index", new[] { 0, 1, 2 }));
660
right.
Columns
.Add(new Int32DataFrameColumn("G1", new[] { 0, 1, 1 }));
661
right.
Columns
.Add(new Int32DataFrameColumn("G2", new[] { 1, 1, 2 }));
662
right.
Columns
.Add(new StringDataFrameColumn("G3", new[] { "Z", "Y", "B" }));
694
Assert.Equal(merge.
Columns
.Count, left.
Columns
.Count + right.
Columns
.Count);
711
Assert.Equal(0, (int)merge.
Columns
["Int_left"][0]);
712
Assert.Equal(1, (int)merge.
Columns
["Int_left"][1]);
726
Assert.NotNull(merge.
Columns
.GetBooleanColumn("Bool_left"));
727
Assert.NotNull(merge.
Columns
.GetBooleanColumn("Bool_right"));
729
Assert.NotNull(merge.
Columns
.GetDecimalColumn("Decimal_left"));
730
Assert.NotNull(merge.
Columns
.GetDecimalColumn("Decimal_right"));
732
Assert.NotNull(merge.
Columns
.GetSingleColumn("Float_left"));
733
Assert.NotNull(merge.
Columns
.GetSingleColumn("Float_right"));
735
Assert.NotNull(merge.
Columns
.GetDoubleColumn("Double_left"));
736
Assert.NotNull(merge.
Columns
.GetDoubleColumn("Double_right"));
738
Assert.NotNull(merge.
Columns
.GetByteColumn("Byte_left"));
739
Assert.NotNull(merge.
Columns
.GetByteColumn("Byte_right"));
741
Assert.NotNull(merge.
Columns
.GetCharColumn("Char_left"));
742
Assert.NotNull(merge.
Columns
.GetCharColumn("Char_right"));
744
Assert.NotNull(merge.
Columns
.GetInt16Column("Short_left"));
745
Assert.NotNull(merge.
Columns
.GetInt16Column("Short_right"));
747
Assert.NotNull(merge.
Columns
.GetUInt16Column("Ushort_left"));
748
Assert.NotNull(merge.
Columns
.GetUInt16Column("Ushort_right"));
750
Assert.NotNull(merge.
Columns
.GetInt32Column("Int_left"));
751
Assert.NotNull(merge.
Columns
.GetInt32Column("Int_right"));
753
Assert.NotNull(merge.
Columns
.GetUInt32Column("Uint_left"));
754
Assert.NotNull(merge.
Columns
.GetUInt32Column("Uint_right"));
756
Assert.NotNull(merge.
Columns
.GetInt64Column("Long_left"));
757
Assert.NotNull(merge.
Columns
.GetInt64Column("Long_right"));
759
Assert.NotNull(merge.
Columns
.GetUInt64Column("Ulong_left"));
760
Assert.NotNull(merge.
Columns
.GetUInt64Column("Ulong_right"));
762
Assert.NotNull(merge.
Columns
.GetDateTimeColumn("DateTime_left"));
763
Assert.NotNull(merge.
Columns
.GetDateTimeColumn("DateTime_right"));
771
for (int i = 0; i < merge.
Columns
["Int_left"].Length; i++)
773
if (merge.
Columns
["Int_left"][i] == null)
775
intersection.Add((int)merge.
Columns
["Int_left"][i]);
777
for (int i = 0; i < left.
Columns
["Int"].Length; i++)
779
if (left.
Columns
["Int"][i] != null && intersection.Contains((int)left.
Columns
["Int"][i]))
780
intersection.Remove((int)left.
Columns
["Int"][i]);
787
for (int i = 0; i < merge.
Columns
["Int_right"].Length; i++)
789
if (merge.
Columns
["Int_right"][i] == null)
791
intersection.Add((int)merge.
Columns
["Int_right"][i]);
793
for (int i = 0; i < right.
Columns
["Int"].Length; i++)
795
if (right.
Columns
["Int"][i] != null && intersection.Contains((int)right.
Columns
["Int"][i]))
796
intersection.Remove((int)right.
Columns
["Int"][i]);
DataFrameTests.Sort.cs (9)
20
df.
Columns
["Int"][0] = 100000;
21
df.
Columns
["Int"][df.Rows.Count - 1] = -1;
22
df.
Columns
["Int"][5] = 200000;
28
Assert.Null(sortedDf.
Columns
["Int"][sortedDf.Rows.Count - 1]);
29
Assert.Equal(1, sortedDf.
Columns
["Int"][0]);
30
Assert.Equal(100000, sortedDf.
Columns
["Int"][sortedDf.Rows.Count - 3]);
31
Assert.Equal(200000, sortedDf.
Columns
["Int"][sortedDf.Rows.Count - 2]);
119
for (int i = 0; i < sortedDataFrame.
Columns
.Count; i++)
121
string columnName = sortedDataFrame.
Columns
[i].Name;
DataFrameTests.Utils.cs (20)
27
dataFrame.
Columns
.Insert(0, dataFrameColumn1);
28
dataFrame.
Columns
.Insert(1, dataFrameColumn2);
88
df.
Columns
.Insert(df.
Columns
.Count, vBufferColumn);
97
df.
Columns
.Insert(df.
Columns
.Count, arrowStringColumn);
106
df.
Columns
.Insert(df.
Columns
.Count, boolColumn);
118
df.
Columns
.Insert(df.
Columns
.Count, boolColumn);
130
df.
Columns
.Insert(df.
Columns
.Count, stringColumn);
137
df.
Columns
.Insert(df.
Columns
.Count, charColumn);
151
df.
Columns
.Insert(df.
Columns
.Count, dateTimeColumn);
194
for (var i = 0; i < dataFrame.
Columns
.Count; i++)
196
dataFrame.
Columns
[i][length / 2] = null;
213
for (int i = 0; i < dataFrame.
Columns
.Count; i++)
215
dataFrame.
Columns
[i][length / 2] = null;
PrimitiveDataFrameColumnTests.cs (9)
497
Assert.True(filteredNullDf.
Columns
.IndexOf("col") >= 0);
498
Assert.Equal(3, filteredNullDf.
Columns
["col"].Length);
500
Assert.Equal(1.23, filteredNullDf.
Columns
["col"][0]);
501
Assert.Equal(2.0, filteredNullDf.
Columns
["col"][1]);
502
Assert.Equal(3.0, filteredNullDf.
Columns
["col"][2]);
514
Assert.True(filteredNullDf.
Columns
.IndexOf("col") >= 0);
515
Assert.True(filteredNullDf.
Columns
.IndexOf("index") >= 0);
519
Assert.Equal(2, filteredNullDf.
Columns
["index"][0]);
520
Assert.Equal(5, filteredNullDf.
Columns
["index"][1]);