Reading a CSV File
Part of the C# and .NET Basics section of Coddy's ASP.NET Core journey. Lesson 16 of 20.
Banks and spreadsheets export data as CSV: one record per line, with commas between the values. File.ReadAllLines(path) returns a file's lines as a string[], and line.Split(',') cuts a line at each comma:
foreach (var line in File.ReadAllLines("scores.txt"))
{
var parts = line.Split(',');
var points = int.Parse(parts[1]);
Console.WriteLine($"{parts[0]} scored {points}");
}For a line Ada,42 this prints Ada scored 42. A missing file throws a FileNotFoundException, so check File.Exists first. File.ReadLines does the same job one line at a time, which suits files too big to hold in memory. Real CSV can put commas inside quoted values; a CSV library handles that, and the files here have none.
Challenge
EasyYour project now has bank.txt, three expenses in CSV form. Add an import command that adds the lines of such a file.
- Add
case "import":abovedefault:. Without a file name, writeUsage: import <file>to stderr andreturn 1;. When the file does not exist, writeNo file named nope.txt.(with the name given) to stderr andreturn 1;. - For each line, split it at the commas and add an
Expensewith the name, the amount parsed withdecimal.ParseandCultureInfo.InvariantCulture, and the category. Count the lines you add. - Save the list once, after the loop, and print:
Imported 3 expenses from bank.txt. - Give
helpan arm for it, above_:help importprintsimport <file>: adds the expenses in a CSV file.
Try it: the terminal beside the editor already reads dotnet run -- import bank.txt, so press Run: the line above. Add a line Lamp,25.00,home to bank.txt and Run again: Imported 4 expenses from bank.txt.
Try it yourself
using System.Globalization;
using System.Text.Json;
var file = "expenses.json";
var expenses = new List<Expense>();
if (File.Exists(file))
{
expenses = JsonSerializer.Deserialize<List<Expense>>(File.ReadAllText(file)) ?? new List<Expense>();
}
var budgets = new Dictionary<string, decimal>();
if (File.Exists("budgets.json"))
{
budgets = JsonSerializer.Deserialize<Dictionary<string, decimal>>(File.ReadAllText("budgets.json")) ?? new Dictionary<string, decimal>();
}
var count = expenses.Count;
var total = expenses.Sum(e => e.Amount);
if (args.Length == 0)
{
Console.WriteLine("Expense Tracker");
Console.WriteLine($"{count} expenses");
Console.WriteLine($"Total: {total:F2}");
}
else
{
switch (args[0])
{
case "add":
if (args.Length < 3)
{
Console.Error.WriteLine("Usage: add <name> <amount> [category]");
return 1;
}
if (!decimal.TryParse(args[2], CultureInfo.InvariantCulture, out var amount))
{
Console.Error.WriteLine($"Invalid amount: {args[2]}");
return 1;
}
if (amount is <= 0 or > 10000)
{
Console.Error.WriteLine("The amount must be more than 0 and at most 10000.");
return 1;
}
var category = args.Length > 3 ? args[3] : "other";
var expense = new Expense(args[1], amount, category);
expenses.Add(expense);
File.WriteAllText(file, JsonSerializer.Serialize(expenses));
Console.WriteLine($"Added {expense.Name}: {expense.Amount:F2} ({expense.Category})");
if (budgets.TryGetValue(category, out var limit))
{
var spent = expenses.Where(e => e.Category == category).Sum(e => e.Amount);
if (spent > limit)
{
Console.WriteLine($"Over budget for {category}: {spent:F2} of {limit:F2}");
}
}
break;
case "remove":
if (args.Length < 2)
{
Console.Error.WriteLine("Usage: remove <name>");
return 1;
}
Expense? match = expenses.Find(e => e.Name == args[1]);
if (match is null)
{
Console.Error.WriteLine($"No expense named {args[1]}.");
return 1;
}
expenses.Remove(match);
File.WriteAllText(file, JsonSerializer.Serialize(expenses));
Console.WriteLine($"Removed {match.Name}: {match.Amount:F2}");
break;
case "list":
var shown = args.Length > 1 ? expenses.Where(e => e.Category == args[1]).ToList() : expenses;
if (shown.Count == 0)
{
Console.WriteLine("No expenses.");
break;
}
foreach (var line in shown.Select(e => $"{e.Name}: {e.Amount:F2} ({e.Category})"))
{
Console.WriteLine(line);
}
break;
case "top":
var howMany = 3;
if (args.Length > 1 && !int.TryParse(args[1], out howMany))
{
Console.Error.WriteLine($"Invalid number: {args[1]}");
return 1;
}
var biggest = expenses.OrderByDescending(e => e.Amount).Take(howMany);
foreach (var line in biggest.Select((e, i) => $"{i + 1}. {e.Name}: {e.Amount:F2} ({e.Category})"))
{
Console.WriteLine(line);
}
break;
case "categories":
var groups = expenses.GroupBy(e => e.Category).OrderByDescending(g => g.Sum(e => e.Amount));
foreach (var g in groups)
{
Console.WriteLine($"{g.Key}: {g.Sum(e => e.Amount):F2} ({g.Count()})");
}
break;
case "help":
var topic = args.Length > 1 ? args[1] : "";
var help = topic switch
{
"" => "Type help <command>, such as help add.",
"add" => "add <name> <amount> [category]: saves an expense",
"remove" => "remove <name>: deletes the first expense with that name",
"list" => "list [category]: shows the saved expenses",
"top" => "top [n]: shows the n biggest expenses, 3 by default",
"categories" => "categories: shows the total of each category",
_ => $"No help for {topic}.",
};
Console.WriteLine(help);
break;
default:
Console.Error.WriteLine($"Unknown command: {args[0]}");
return 1;
}
}
return 0;