public void WriteCsvQuoted_ToFile_Test() { var filepath = "write_quoted_test.csv"; var array = np.arange(100).reshape(20, 5); var columnNames = new string[] { "first", "second", "third", "fourth", "fifth" }; var pd = new Pandas(); IDataFrame df1 = pd.DataFrame(array, null, columnNames, typeof(object)); df1.to_csv(filepath, quoting: 1); using (var fr = File.OpenText(filepath)) { Assert.Equal(string.Join(',', columnNames), fr.ReadLine()); for (var i = 0; i < array.shape[0]; i++) { Assert.Equal('"' + string.Join("\",\"", array[i].Data <int>()) + '"', fr.ReadLine()); } } }
public void WriteCsvFormated_ToFile_Test() { var filepath = "write_quoted_test.csv"; var array = np.arange(0, 50, 0.5).reshape(20, 5); var columnNames = new string[] { "first", "second", "third", "fourth", "fifth" }; var floatFormat = "E03"; var pd = new Pandas(); IDataFrame df1 = pd.DataFrame(array, null, columnNames, typeof(object)); df1.to_csv(filepath, float_format: floatFormat); using (var fr = File.OpenText(filepath)) { Assert.Equal(string.Join(',', columnNames), fr.ReadLine()); for (var i = 0; i < array.shape[0]; i++) { var formattedData = array[i].Data <double>().Select( x => x.ToString(floatFormat)); Assert.Equal(string.Join(",", formattedData), fr.ReadLine()); } } }