this is my csv file format:
Date, Currency_Name, Currency_Name, Currency_Name, Currency_Name, Currency_Name, Currency_Name, Currency_Name, Currency_Name, Currency_Name, Currency_Name, Currency_Name, Currency_Name, Currency_Name, Currency_Name, Currency_Name, Currency_Name, Currency_Name, Currency_Name, Currency_Name, Currency_Name, Currency_Name, Currency_Name, Currency_Name, Currency_Name, Currency_Name, Currency_Name, Currency_Name, Currency_Name, Currency_Name, Currency_Name, Currency_Name, 24 October 2016, 1.0891, 113.29, 1.9558, 27.021, 7.4394, 0.89015, 308.53, 4.3166, 4.5065, 9.7050, 1.0821, 8.9855, 7.5083, 67.7970, 3.3501, 1.4282, 3.4200, 1.4547, 7.3775, 8.4478, 14178.99, 72.7975, 1234.29, 20.2263, 4.5444, 1.5215, 52.562, 1.5159, 38.119, 15.1167, 4.2057
I want to convert like this
Date Currency Rate
24/10/2016 Currency_Name 0.3514
24/10/2016 Currency_Name 0.0843
24/10/2016 Currency_Name 0.7403
24/10/2016 Currency_Name 3.430
What I have tried:
private static DataTable getCSVData(string csv_file_path)
{
String[] values = File.ReadAllText(csv_file_path).Split(',');
DataTable dt = new DataTable();
dt.Columns.Add("Date");
dt.Columns.Add("Currency");
dt.Columns.Add("Rate");
for(int i =0;i<=0;i++)
{
DataRow row = dt.NewRow();
row["Date"] = Convert.ToDateTime(values[32]).ToString("dd/MM/yyyy");
row["Currency"] = values[1];
row["Rate"] = values[33];
row["Date"] = Convert.ToDateTime(values[32]).ToString("dd/MM/yyyy");
row["Currency"] = values[2];
row["Rate"] = values[34];
row["Date"] = Convert.ToDateTime(values[32]).ToString("dd/MM/yyyy");
row["Currency"] = values[3];
row["Rate"] = values[35];
row["Date"] = Convert.ToDateTime(values[32]).ToString("dd/MM/yyyy");
row["Currency"] = values[4];
row["Rate"] = values[36];
row["Date"] = Convert.ToDateTime(values[32]).ToString("dd/MM/yyyy");
row["Currency"] = values[5];
row["Rate"] = values[37];
row["Date"] = Convert.ToDateTime(values[32]).ToString("dd/MM/yyyy");
row["Currency"] = values[6];
row["Rate"] = values[38];
row["Date"] = Convert.ToDateTime(values[32]).ToString("dd/MM/yyyy");
row["Currency"] = values[7];
row["Rate"] = values[39];
row["Date"] = Convert.ToDateTime(values[32]).ToString("dd/MM/yyyy");
row["Currency"] = values[8];
row["Rate"] = values[40];
row["Date"] = Convert.ToDateTime(values[32]).ToString("dd/MM/yyyy");
row["Currency"] = values[9];
row["Rate"] = values[41];
row["Date"] = Convert.ToDateTime(values[32]).ToString("dd/MM/yyyy");
row["Currency"] = values[10];
row["Rate"] = values[42];
row["Date"] = Convert.ToDateTime(values[32]).ToString("dd/MM/yyyy");
row["Currency"] = values[11];
row["Rate"] = values[43];
row["Date"] = Convert.ToDateTime(values[32]).ToString("dd/MM/yyyy");
row["Currency"] = values[12];
row["Rate"] = values[44];
row["Date"] = Convert.ToDateTime(values[32]).ToString("dd/MM/yyyy");
row["Currency"] = values[13];
row["Rate"] = values[45];
row["Date"] = Convert.ToDateTime(values[32]).ToString("dd/MM/yyyy");
row["Currency"] = values[14];
row["Rate"] = values[46];
row["Date"] = Convert.ToDateTime(values[32]).ToString("dd/MM/yyyy");
row["Currency"] = values[15];
row["Rate"] = values[47];
row["Date"] = Convert.ToDateTime(values[32]).ToString("dd/MM/yyyy");
row["Currency"] = values[16];
row["Rate"] = values[48];
row["Date"] = Convert.ToDateTime(values[32]).ToString("dd/MM/yyyy");
row["Currency"] = values[17];
row["Rate"] = values[49];
row["Date"] = Convert.ToDateTime(values[32]).ToString("dd/MM/yyyy");
row["Currency"] = values[18];
row["Rate"] = values[50];
row["Date"] = Convert.ToDateTime(values[32]).ToString("dd/MM/yyyy");
row["Currency"] = values[19];
row["Rate"] = values[51];
row["Date"] = Convert.ToDateTime(values[32]).ToString("dd/MM/yyyy");
row["Currency"] = values[20];
row["Rate"] = values[52];
row["Date"] = Convert.ToDateTime(values[32]).ToString("dd/MM/yyyy");
row["Currency"] = values[21];
row["Rate"] = values[53];
row["Date"] = Convert.ToDateTime(values[32]).ToString("dd/MM/yyyy");
row["Currency"] = values[22];
row["Rate"] = values[54];
row["Date"] = Convert.ToDateTime(values[32]).ToString("dd/MM/yyyy");
row["Currency"] = values[23];
row["Rate"] = values[55];
row["Date"] = Convert.ToDateTime(values[32]).ToString("dd/MM/yyyy");
row["Currency"] = values[24];
row["Rate"] = values[56];
row["Date"] = Convert.ToDateTime(values[32]).ToString("dd/MM/yyyy");
row["Currency"] = values[25];
row["Rate"] = values[57];
row["Date"] = Convert.ToDateTime(values[32]).ToString("dd/MM/yyyy");
row["Currency"] = values[26];
row["Rate"] = values[58];
row["Date"] = Convert.ToDateTime(values[32]).ToString("dd/MM/yyyy");
row["Currency"] = values[27];
row["Rate"] = values[59];
row["Date"] = Convert.ToDateTime(values[32]).ToString("dd/MM/yyyy");
row["Currency"] = values[28];
row["Rate"] = values[60];
row["Date"] = Convert.ToDateTime(values[32]).ToString("dd/MM/yyyy");
row["Currency"] = values[29];
row["Rate"] = values[61];
row["Date"] = Convert.ToDateTime(values[32]).ToString("dd/MM/yyyy");
row["Currency"] = values[30];
row["Rate"] = values[62];
row["Date"] = Convert.ToDateTime(values[32]).ToString("dd/MM/yyyy");
row["Currency"] = values[31];
row["Rate"] = values[63];
dt.Rows.Add(row);
}
return dt;
}