// Read in a Ascii file that uses the given separate characters. // Like CSV. // Supports quotes to escape commas public static MutableDataTable Read(string filename, char separator = '\0', bool fAllowMismatch = false, string[] defaultColumns = null) { var dtLazy = new FileStreamingDataTable(filename, defaultColumns, separator); var dt = Utility.ToMutable(dtLazy); dt.Name = filename; return(dt); }
/// <summary> /// Return an in-memory table that contains the topN rows from the table in the filename. /// </summary> /// <param name="builder">ignored</param> /// <param name="filename">filename of table to load. Schema is inferred from header row.</param> /// <param name="topN">reads the topN rows from the table.</param> /// <returns>a in-memory table containing the topN rows from the supplied file.</returns> public static MutableDataTable ReadSampleTopN(this DataTableBuilder builder, string filename, int topN = 100) { Debug.Assert(builder != null); if (filename == null) { throw new ArgumentNullException("filename"); } DataTable source = new FileStreamingDataTable(filename); MutableDataTable dt = Analyze.SampleTopN(source, topN); return(dt); }
// Read in a Ascii file that uses the given separate characters. // Like CSV. // Supports quotes to escape commas public static MutableDataTable Read(string filename, char separator = '\0', bool fAllowMismatch = false, string[] defaultColumns = null) { var dtLazy = new FileStreamingDataTable(filename, defaultColumns, separator); var dt = Utility.ToMutable(dtLazy); dt.Name = filename; return dt; }