Sencer.DataFrame 1.0.3

Addeds: DataFrameData.SockRsi indicator DataFrame.Short method

DataFrame It is the implementation of Python dataframe on C#. In this project, SciSharp's pandas.net project was used. see https://github.com/SciSharp/Pandas.NET

Usage Methods Creation Create without parameters

DataFrame dataframe = new DataFrame();

Create by giving column name.

DataFrame dataframe = new DataFrame(new string[]{"col1","col2","col3");

Creating dataframedata array and column names as parameters. The column names parameter can be left blank. In this case, alphabetical letters are determined as the column name. Ex: "A","B","C". Naming is done according to the number of dataframedata.If column names are given, data is retrieved as many as the number of columns. Even if the number of columns is more than the number of data, as many columns as the number of data are created.

List<DataFrameData> list = new List<DataFrameData>(5); string[] colls1 = new string[7]; string[] colls2 = new string[4]; DataFrame dataframe1 = new DataFrame(list,colls1); DataFrame dataframe2 = new DataFrame(list,colls2);

Creating dataframe with single dataframedata.The column name parameter can be left blank. In this case, the column name is determined as the letter a

DataFrame = new DataFrame(new DataFrameData,"col1");

Creating Dataframe with dictinoary data type.The column names parameter can be left blank.

Dictionary<string,IConvertible[]> list = new DDictionary<string,IConvertible[]>(5); string[] colls1 = new string[7]; string[] colls2 = new string[4]; DataFrame dataframe1 = new DataFrame(list,colls1); DataFrame dataframe2 = new DataFrame(list,colls2);

Creating Dataframe with custom object type. Column names will be the names of the object elements.

public class CustomClass{ public int Int1 { get; set; } public string String1 { get; set; } public decimal Decimal1 { get; set; } public DateTime DateTime1 { get; set; } } List<CustomClass> customlist = new List<CustomClass>(4); DataFrame dataframe1 = new DataFrame(customlist);

DataFrame Items

Columns: Returns columns in dictionary format

Count: Returns the number of rows of any column. The row numbers of all columns must be equal. Methods

AddRow: Adds new line. The added row must contain all columns.

IConvertible[] row = new IConvertible[] { DateTime.Now, 5, "row3", 6.0m, 5.13d }; List<IConvertible> row2 = new List<IConvertible>(){DateTime.Now, 5, "row3", 6.0m, 5.13}; dataframe.AddRow(row); dataframe.AddRow(3,row2); // by giving line number

DeleteRow: deletes the line given the line number

dataframe.DeleteRow(1);

Clear: clears all lines

dataframe.Clear();

Rename: Replaces the column name with the new name. It must be in Dictionary<string,string> format.

dataframe.Rename(new Dictionary<string,string>(){{"col1","newcol1"},{"col2","newcoll2"}};

Short: Reorder all rows with given column name.

dataframe.Short("T",ShortSide.Desc); Indexing

DataFrameData this[string collname]: Returns the column called column as Dataframedata.

var dataframe2 = dataframe1["coll1"];

DataFrameData this[string collname, int rowstart, int rowend]: Returns the column called column as Dataframedata within the specified range.

var dataframe2 = dataframe1["coll1", 1, 5];

IConvertible? this[string collname, int row]: Returns the data in the specified row and column.

var data = dataframe1["coll1", 1];

List<IConvertible?> this[int row]: Returns the data in the form of a list in the given row.

var datas = dataframe1[1];

DataFrame this[string[] colls]: Returns the columns given as parameters as DataFrame.

var dataframe2 = dataframe1[new string[]{"col1","col2"}];

Columns can be added later using the indexing method.The column to be added must have data. The size of the DataFrameData to be added must be the same as the DataFrame. If the DataFrame is empty, the size will be the DataFrameData size. ex:

var dataframe = new DataFrame(); dataframe["col1"]=new DataFrameData(typeof(int),10); In this example, a new column named col1 has been added. The value of the data can be changed with the indexing method. ex:

dataframe["col1",3] = 12; DataFrameData

This is the most comprehensive object. Mathematical operations, comparison, averaging and square root operations can be performed with DataFrameData. All data types used must be of nullable type. Example: new DataFrameData(new int?[5]) Usage Methods Creation Create by specifying type and size

DataFrameData dataframedata = new DataFrame(typeof(int),10);

Create with array

float[] array = new float[]{3.5, 2.75, 1.43, 14.6}; DataFrameData dataframedata = new DataFrame(array); DataFrameData Items

Values: Array of values

Type: DataFrameData type of data of the data. Methods

Add: Add new data

DataFrameData dataframedata = new DataFrameData(typeof(int),3); dataframedata.Add(5); dataframedata.Add(0,5); //Adding data with index number

Delete: Deletes the data given the index number

DataFrameData dataframedata = new DataFrameData(typeof(int),3); dataframedata.Delete(1);

Clear: Clears all data

DataFrameData dataframedata = new DataFrameData(typeof(int),3); dataframedata.Celar();

ToString: Converts data to string in tabular form

DataFrameData dataframedata = new DataFrameData(typeof(int),3); Console.WriteLine(dataframedata.ToString());

ShiftLeft: Shifts the array to the left by the given number. Initial values ​​are assigned as null

DataFrameData dataframedata = new DataFrameData(typeof(int),10); dataframedata2 = dataframedata.ShiftLeft(1);

ShiftRight: Shifts the array to the right by the given number. Initial values ​​are assigned as null

DataFrameData dataframedata = new DataFrameData(typeof(int),10); dataframedata2 = dataframedata.ShiftRight(2);

index: Returns the index number of the given data

DataFrameData dataframedata = new DataFrameData(typeof(decimal),5); int index = dataframedata.index(10m);

ForEach: Foreach method used in the list method

DataFrameData dataframedata = new DataFrameData(typeof(decimal),7); dataframedata.ForEach(Console.WriteLine);

Rolling: Implementation of pandas.rolling function. For explanation: here

DataFrameData dataframedata = new DataFrameData(typeof(decimal),128); List<DataFrameData> datalist = dataframedata.Rolling(5);

First: Returns the first data

IConvertible? data = dataframedata.First();

Last: Returns the last data

IConvertible? data = dataframedata.Last();

Count: Returns the total number of data

int size = dataframedata.Count();

Sum: Returns the total of the datas

IConvertible sum = dataframedata.Sum();

Mean: Averages the datas

IConvertible mean = dataframedata.Mean();

Min: Returns the minimum of all data

IConvertible min = dataframedata.Min();

Max: Returns the maximum of all data

IConvertible max = dataframedata.Max();

Abs: Returns the absolute value of a number

DataFrameData abs = dataframedata.Abs();

Diff: Find the difference between the values for each row and the values from the previous row

DataFrameData diff = dataframedata.Diff();

Clip: Used to trim values at specified input threshold. We can use this function to put a lower limit and upper limit on the values that any cell can have in the dataframe.

DataFrameData clip = dataframedata.Clip();

Std: Return sample standard deviation over requested axis.

DataFrameData std = dataframedata.Std();

Join: merge existing DataFrameData with DataFrameData given in parameter

DataFrameData joins = dataframedata.Join(dataframedata2,"both");

Ewm: ewm method used in pandas.dataframe

DataFrameData ewm = dataframedata.Ewm(21);

Sma: sma indicator

DataFrameData sma = dataframedata.Sma(50);

Ema: ema indicator

DataFrameData ema = dataframedata.Ema(17);

Wma: wma indicator

DataFrameData wma = dataframedata.Wma(18);

Hma: hma indicator

DataFrameData hma = dataframedata.Hma(18);

StockRsi: stochastic rsi indicator

DataFrameData stock = dataframedata.StockRsi(14,3); Indexing

Returns the data given the index number

IConvertible data = dataframedata[1];

Index number returns data up to the size of the given number.

DataFrameData dataframedata2 = dataframedata[1,3]; //The size of the new DataFrameData is 3 Operators Contain Operators ==, != , >, <, >=, ⇐, & Operators:

DataFrameData newDataFrameData = dataframedata1 == dataframedata2; //The values ​​of the new dataframedata will be of type bool DataFrameData newDataFrameData = dataframedata1 != dataframedata2; DataFrameData newDataFrameData = dataframedata1 > dataframedata2; DataFrameData newDataFrameData = dataframedata1 & dataframedata2; //Do not use it with two & characters. It will be single & character ....

Math Operators +, -, *, /, ++, --, % Operators:

DataFrameData newDataFrameData = dataframedata1 == dataframedata2; //The values ​​of the new dataframedata will be of type bool DataFrameData newDataFrameData = dataframedata1 + dataframedata2; DataFrameData newDataFrameData = dataframedata1 / dataframedata2; DataFrameData newDataFrameData = dataframedata1 % dataframedata2; DataFrameData newDataFrameData = dataframedata1++; ....

Examples

DataFrame dataframe = new DataFrame(); dataframe["T"] = new DataFrameData(new DateTime?[5]{DateTime.Parse("01.01.2024","02.01.2024","03.01.2024","04.01.2024","05.01.2024"}); dataframe["high"] = new DataFrameData(new decimal?[5]{"5.12,6.25,5.13,8.26,15}); dataframe["low"] = new DataFrameData(new decimal?[5]{"4.48,5.15,3.27,7.55,11,45}); dataframe["close"] = new DataFrameData(new decimal?[5]{"4.51,5.18,3.51,7.99,13,74}); dataframe["hl2"] = (dataframe["high"]+dataframe["low"])/2; //Calculate 10 days sma dataframe["sma"] = dataframe["close"].Rolling(10).Mean();

//Buy Sell indicator dataframe["buy"] = General.Where(dataframe["close"] < dataframe["low"].ShiftLeft(),"BUY",""); //Buy if the close is less than the previous low dataframe["sell"] = General.Where(dataframe["close"] > dataframe["high"].ShiftLeft(),"SELL",""); //Sell ​​if the close is higher than the previous high dataframe["buysell"] = dataframe["buy"].Join(dataframe["sell"],""); //Combine buy and sell and put them in one column