本文整理匯總了C#中System.Data.DataTable.ReadCsv方法的典型用法代碼示例。如果您正苦於以下問題：C# DataTable.ReadCsv方法的具體用法？C# DataTable.ReadCsv怎麽用？C# DataTable.ReadCsv使用的例子？那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在類System.Data.DataTable的用法示例。
在下文中一共展示了DataTable.ReadCsv方法的5個代碼示例，這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚，您的評價將有助於係統推薦出更棒的C#代碼示例。
示例1: Merge
public static void Merge()
{
var dt1 = new DataTable();
dt1.ReadCsv(@"visual\visual_internal_warxlsx.csv");
var dt2 = new DataTable();
dt2.ReadCsv(@"visual\visual_external.csv");
var dt3 = new DataTable();
dt3.ReadCsv(@"visual\visual_suicde_attack_db.csv");
var dt4 = new DataTable();
dt4.ReadCsv(@"visual\visual_peace.csv");
var mergedDt = new DataTable();
foreach (DataColumn column in dt1.Columns)
{
mergedDt.Columns.Add(new DataColumn(column.ColumnName));
}
foreach (DataRow row in dt1.Rows)
{
var newRow = mergedDt.NewRow();
newRow[0] = Convert.ToDateTime(row[0]).ToString("yyyy-MM-dd");
//newRow[1] = Convert.ToDateTime(row[1]).ToString("yyyy-MM-dd");
newRow[2] = row[2];
newRow[3] = row[3];
mergedDt.Rows.Add(newRow);
}
foreach (DataRow row in dt2.Rows)
{
var newRow = mergedDt.NewRow();
newRow[0] = Convert.ToDateTime(row[0]).ToString("yyyy-MM-dd");
//newRow[1] = Convert.ToDateTime(row[1]).ToString("yyyy-MM-dd");
newRow[2] = row[2];
newRow[3] = row[3];
mergedDt.Rows.Add(newRow);
}
foreach (DataRow row in dt3.Rows)
{
var newRow = mergedDt.NewRow();
newRow[0] = Convert.ToDateTime(row[0]).ToString("yyyy-MM-dd");
//newRow[1] = Convert.ToDateTime(row[1]).ToString("yyyy-MM-dd");
newRow[2] = row[2];
newRow[3] = row[3];
mergedDt.Rows.Add(newRow);
}
foreach (DataRow row in dt4.Rows)
{
var newRow = mergedDt.NewRow();
newRow[0] = Convert.ToDateTime(row[0]).ToString("yyyy-MM-dd");
//newRow[1] = Convert.ToDateTime(row[1]).ToString("yyyy-MM-dd");
newRow[2] = row[2];
newRow[3] = row[3];
mergedDt.Rows.Add(newRow);
}
IEnumerable<DataRow> query = mergedDt.AsEnumerable().OrderBy(q => q[0]);
// Create a table from the query.
DataTable boundTable = query.CopyToDataTable<DataRow>();
boundTable.WriteCsv(@"visual\result.csv");
}示例2: Convert_SuicideAttackDb
//suicide attack db
public static void Convert_SuicideAttackDb()
{
string[] attackCategory = new[]
{
"Attack Date",
"Location",
"Campaign",
"Group",
"Weapon",
"Target",
"Target type",
};
// Attack Date, Location, Campaign, Group, Weapon, Target, Target type
var dt = new DataTable();
dt.ReadCsv(@"origin\suicide_attack_db_2011-2015.06.csv");
// start, end, label, description
var makeDt = new DataTable();
makeDt.SetColumns(Category);
// 첫번재 값 제외
foreach (DataRow row in dt.Rows)
{
var makeRow = makeDt.NewRow();
makeRow[Category[0]] = row[attackCategory[0]];
makeRow[Category[1]] = row[attackCategory[0]];
makeRow[Category[2]] = row[attackCategory[1]];
makeRow[Category[3]] = row[attackCategory[1]];
makeDt.Rows.Add(makeRow);
}
makeDt.WriteCsv(@"visual\visual_suicde_attack_db.csv");
}示例3: Converter_Classify
public static void Converter_Classify()
{
var orgin = new DataTable();
orgin.ReadCsv(@"visual\Martyrs3.csv");
// 매 달마다 사망자수
var deathClassfy = orgin.AsEnumerable().GroupBy(q => q[4]);
List<string> deathListh = new List<string>();
Console.WriteLine("Classfy Death");
foreach (var death in deathClassfy)
{
Console.WriteLine($"Area.Key : {death.Key}, Area.Count : {death.Count()}");
deathListh.Add(death.Key.ToString());
}
string str = String.Empty;
foreach (var death in deathListh)
{
str += death + ",";
}
Console.WriteLine($"Total : {orgin.Rows.Count}");
Console.WriteLine($"Classify Count : {deathClassfy.Count()}");
Console.WriteLine("end");
var makeDt = new DataTable();
makeDt.SetColumns(Category);
//start: 해당 달에 밝혀진 사망자 수
//label : 전체 사망자 수
//description : 전체 사망자 수
// 월별로 정리
// 모든 Day를 1로 정의
foreach (DataRow row in orgin.Rows)
{
try
{
DateTime date = Convert.ToDateTime(row[6]);
// .ToString("yyyy-MM-dd")
var day = date.Day;
if (day > 1)
{
var sub = 1 - day;
date = date.AddDays(sub);
}
row[6] = date.ToString("yyyy-MM-dd");
}
catch (Exception)
{
}
}
//orgin.WriteCsv(@"visual\Martyrs5.csv");
Debug.WriteLine("end");
// groupby를 통하 합침.
// 이를 날짜별로 정리
var dateClassfy = orgin.AsEnumerable().GroupBy(q => q[6]).OrderBy(q => q.Key);
//foreach (var dateData in dateClassfy)
//{
// var deathClassify = dateData.GroupBy(q => q[7]);
//}
// 사망 지역
var makeDt3 = new DataTable();
makeDt3.SetColumns(new string[]
{
"date",
"total_count",
"Hama",
"Damascus Suburbs","Damascus",
"Daraa","Deir Ezzor",
"Idlib",
"Aleppo",
"Homs",
"Lattakia",
"Quneitra",
"Other",
"Hasakeh",
"Raqqa",
"Tartous",
"Sweida"
});
foreach (var dateData in dateClassfy)
{
var row = makeDt3.NewRow();
row[0] = dateData.Key;
row[1] = dateData.Count();
var deathClassify = dateData.GroupBy(q => q[4]);
foreach (var classify in deathClassify)
{
string name = classify.Key.ToString();
if (String.IsNullOrEmpty(name) == false)
{
if (String.IsNullOrEmpty(name))
{
}
//.........這裏部分代碼省略.........
示例4: Convert_peace
public static void Convert_peace()
{
// 시작 날짜,종료 날짜,사건 이름,설명,지역,위도,경도,행정구역,Refenence Link,올린사람,비고
var dt = new DataTable();
dt.ReadCsv(@"origin\peace.csv");
// start, end, label, description
var makeDt = new DataTable();
makeDt.SetColumns(Category);
// 첫번재 값 제외
foreach (DataRow row in dt.Rows)
{
var makeRow = makeDt.NewRow();
makeRow[Category[0]] = row[0];
makeRow[Category[1]] = row[0];
makeRow[Category[2]] = row[2];
makeRow[Category[3]] = row[3];
makeDt.Rows.Add(makeRow);
}
makeDt.WriteCsv(@"visual\visual_peace.csv");
}示例5: Convert_Martyrs
public static void Convert_Martyrs()
{
var orgin = new DataTable();
orgin.ReadCsv(@"visual\Martyrs3.csv");
//var deathClassfy = orgin.AsEnumerable().GroupBy(q => q[7]);
//Console.WriteLine("Classfy Death");
//foreach (var death in deathClassfy)
//{
// Console.WriteLine($"death.Key : {death.Key}, death.Count : {death.Count()}");
//}
//Console.WriteLine($"Total : {orgin.Rows.Count}");
//Console.WriteLine("end");
// start, end, label, description
var makeDt = new DataTable();
makeDt.SetColumns(Category);
//start: 해당 달에 밝혀진 사망자 수
//label : 전체 사망자 수
//description : 전체 사망자 수
// 월별로 정리
// 모든 Day를 1로 정의
foreach (DataRow row in orgin.Rows)
{
try
{
DateTime date = Convert.ToDateTime(row[6]);
// .ToString("yyyy-MM-dd")
var day = date.Day;
if (day > 1)
{
var sub = 1 - day;
date = date.AddDays(sub);
}
row[6] = date.ToString("yyyy-MM-dd");
}
catch (Exception)
{
}
}
orgin.WriteCsv(@"visual\Martyrs5.csv");
Debug.WriteLine("end");
// groupby를 통하 합침.
// 이를 날짜별로 정리
var dateClassfy = orgin.AsEnumerable().GroupBy(q => q[6]).OrderBy(q => q.Key);
var makeDt2 = new DataTable();
makeDt2.SetColumns(new string[] { "date", "num" });
// 월별 사망자수
foreach (var dateData in dateClassfy)
{
var row = makeDt2.NewRow();
row[0] = dateData.Key;
row[1] = dateData.Count();
makeDt2.Rows.Add(row);
}
makeDt2.WriteCsv(@"visual\MartyrsCount.csv");
// 월별 사망자 누적수
makeDt2.Rows.Clear();
int count = 0;
foreach (var dateData in dateClassfy)
{
var row = makeDt2.NewRow();
row[0] = dateData.Key;
count += dateData.Count();
row[1] = count;
makeDt2.Rows.Add(row);
}
makeDt2.WriteCsv(@"visual\MartyrsCount2.csv");
Debug.WriteLine("end");
}