select csv file and add a new column called situation to the first line and for other lines fill the situation with yes or no and move the new csv to destination in csharp

main.cs
using System.IO;

public void AddSituationToCsv(string sourceCsvPath, string destinationFolderPath)
{
    // Read all lines from the source CSV file
    string[] lines = File.ReadAllLines(sourceCsvPath);

    // Add the "situation" column header to the first line
    lines[0] = string.Concat(lines[0], ",situation");

    // Add the "yes" or "no" value to each line except for the first one
    for (int i = 1; i < lines.Length; i++)
    {
        lines[i] = string.Concat(lines[i], ",no");
    }

    // Write the modified CSV data to a new file in the destination folder
    string newCsvFilePath = Path.Combine(destinationFolderPath, Path.GetFileName(sourceCsvPath));
    File.WriteAllLines(newCsvFilePath, lines);
}
721 chars
21 lines

main.cs
string sourceCsvPath = @"C:\path\to\source.csv";
string destinationFolderPath = @"C:\path\to\destination\folder";

AddSituationToCsv(sourceCsvPath, destinationFolderPath);
172 chars
5 lines