public void ImportExcelData()
{
var excelParser = new ExcelParser();
var transactions = excelParser.ImportExcelData();
Assert.IsNotNull(transactions);
Assert.IsTrue(transactions.Any());
var bucurestiTransactions = transactions.Where(f => f.IdJudet == 10).OrderBy(f => f.Data);
Assert.IsTrue(bucurestiTransactions.Any());
var csvTool = new CsvTool();
csvTool.ExportToCsv(bucurestiTransactions, @".\buc.csv");
}
public void ShowSelectScene(Dictionary <int, GameScene> dicScene)
{
string itemName = "SelectSceneItem";
Transform parent = GetNode <Transform>("selectSceneContent");
int sceneCount = dicScene.Count;
int index = 1;
LoadItem(itemName, parent, sceneCount, (UIPrefab itemPrefab) => {
itemPrefab.GetNode <Text>("textScene").text = GameSceneInfo.GetName(dicScene[index]);
itemPrefab.GetNode <Text>("textBtnOpen").text = CsvTool.Text("common_open");
int indexCopy = index;
itemPrefab.GetNode <Button>("btnOpenScene").onClick.AddListener(
() =>
EventManager.Dispatch(GameMoudle.Select, GameEvent.Type.Click, indexCopy)
);
index++;
});
}
void Start()
{
var csv = CsvTool.Read(Application.dataPath + "/Adrenak/CsvTool/test.csv");
var csvAsObjects = CsvTool.Read <Person>(Application.dataPath + "/Adrenak/CsvTool/test.csv");
foreach (var row in csvAsObjects.rows)
{
Debug.Log(row.ToString());
}
Debug.Log("****");
foreach (var row in csv)
{
string rowStr = "";
foreach (var r in row)
{
rowStr += r + " | ";
}
Debug.Log(rowStr);
}
}
private void btnLoadCsv_Click(object sender, RoutedEventArgs e)
{
try
{
var filepath = Dialog.OpenFileDia();
if (filepath == "")
{
return;
}
CsvTool cv = new CsvTool();
var res = cv.ReadCsv2String(filepath, ',');
double head = 0;
if (!Double.TryParse(res [0] [0], out head))
{
res = res.Skip(1).ToArray();
}
var numberList = res.Select(x => x.Select(f => f.ToDouble()).ToArray()).ToArray();
if (numberList.SelectMany(
x => x.Select(k => k),
(f, s) => s)
.Where(x => x == 123456789)
.Count() > 0)
{
Console.WriteLine("Invalid string number is contained.");
return;
}
var inputs = numberList.Select(x => new double[] { x[0], x[1] }).ToArray();
var outputs = numberList.Select(x => x[2]).ToArray();
// LS방식으로는 잘 안되는것 같다. ...... 어코드에서는 다른 알고리즘은 지원을 안하기 때문에, 일단 테스트를 해보고, 잘 맞는 알고리즘을 c#으로 구현을 해야 될 것 같다.
var ols = new OrdinaryLeastSquares()
{
UseIntercept = true
};
MultipleLinearRegression regression = ols.Learn(inputs, outputs);
double[] predicted = regression.Transform(inputs);
double error = new SquareLoss(outputs).Loss(predicted);
var testdata = GridZ(300, 15);
var zdata = regression.Transform(testdata);
var z2ddata = zdata.Reshape(300, 300);
var jagged = z2ddata.ToJagged();
StringBuilder sb = new StringBuilder();
foreach (double[] item in jagged)
{
foreach (var el in item)
{
sb.Append(el.ToString());
sb.Append(",");
}
sb.Append(Environment.NewLine);
}
File.WriteAllText(@"E:\Temp\haha2.csv", sb.ToString());
Console.WriteLine("done");
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
