A fast easy to use csv,tsv file parser. It has a low memory footprint with alot of optimizations to be done.
Kafa is also RFC-4180 Compliant docs
🚧 UNDER ACTIVE DEVELOPMENT 🚧
There are two options;
RowEnumerableIEnumerable<T>
For fast performance with minimal reflection over head the RowEnumerable allows you to iterate over the CSV rows yourself. Example:
var stream = new MemoryStream(Encoding.UTF8.GetBytes(sampleCSV));
using var rows = Kafa.Read(stream);
int rowCount =0, colCount = 0;
foreach (var row in rows)
{
foreach (var col in row.Cols)
{
Debug.WriteLine(col.ToString());
colCount++;
}
rowCount++;
}This offers you the granular control over each element. In addition you can also use Parse<T>() and TryParse<T>(out var val) on Col
Example:
var stream = new MemoryStream(Encoding.UTF8.GetBytes(sampleCSV));
using var rows = Kafa.Read(stream);
int sum =0;
foreach (var row in rows)
{
foreach (var col in row.Cols)
{
sum += col.Parse<int>();
}
}To also make it easier you can jump to a specific Row and Col
Example:
var stream = new MemoryStream(Encoding.UTF8.GetBytes(sampleCSV));
using var rows = Kafa.Read(stream);
var result = rows[0].Cols[0].ToString();
// or
var result2 = rows[new Index(0)].Cols[new Index(0)].ToString();Understanding that many users want a simple easy to use experience the library allows you to parse directly into a type.
Example:
var stream = new MemoryStream(Encoding.UTF8.GetBytes(data));
var result = await Kafa.ReadAsync<CsvData>(stream);To make it easier to parse a file Kafa offers an Attribute Type that can match a column name or the column index.
Example:
class CSVDataWithAttributes
{
[KafaColumn("date")]
public DateTime Date { get; set; }
[KafaColumn(1)]
public double Open { get; set; }
[KafaColumn(2)]
public double High { get; set; }
[KafaColumn(3)]
public double Low { get; set; }
[KafaColumn(4)]
public double Close { get; set; }
[KafaColumn(5)]
public int Volume { get; set; }
[KafaColumn("name")]
public string Name { get; set; }
}You can simply convert a list of objects to a textwriter, stream or a file
var csvs = new List<CSVDataWithAttributes>()
{
new CSVDataWithAttributes{ Date = DateTime.Parse("10/10/2023 4:08:38 PM"), Open=12.45, Close=12.99, High=13.00, Low=12.1, Name="AMZN", Volume=1233435512},
new CSVDataWithAttributes{ Date = DateTime.Parse("10/10/2023 4:08:38 PM"), Open=12.45, Close=12.99, High=13.00, Low=12.1, Name="AMZN", Volume=1233435512}
};
var textWriter = await Kafa.WriteAsync<CsvData>(csvs);
string result = textWriter.ToString();
// or
using var stream = await Kafa.WriteToStreamAsync<CsvData>(csvs);
// or
await Kafa.WriteToFileAsync<CsvData>(csvs,@"C:\Users\ADMIN\Documents");Both writing and reading support Attributes
Only .Net Core 7 and >
John Nyingi