Pandas.NET
Implemented APIs
1. Pandas
- DataFrame
pd.DataFrame(NDArray data, IList<string> index, IList<string> columns, Type dtype)pd.DataFrame<TIndex>(NDArray data, IList<TIndex> index, IList<string> columns, Type dtype)pd.DataFrame(IDictionary<string, NDArray> data, IList<string> index)pd.DataFrame<TIndex>(IDictionary<string, NDArray> data, IList<TIndex> index)
- Series
pd.Series(NDArray data)pd.Series(Array data)pd.Series<T>(T data)
2. Series
-
s.iloc[0]: Select data by index -
s.loc["index_label"]： Select data by index label
3. DataFrame
Structure
- df.Index
- df.Columns
- df.Values
- df.Shape
- df.NDIM
- df.Size
Method
-
df[0]： Select data by column index （returns Series） -
df[params int[] columnIndexs]: Select data by column index （returns DataFrame） -
df["column_label"]： Select data by column label （returns Series）; accessiblesetaccessor increase column （if the column label does not exist） -
df[params string[] columnLabels]： Select data by column label （returns DataFrame） -
df.Column(string columnLabel, NDArray value): Set the column and its value; create when the column does not exist -
df.Column(int columnIndex, NDArray value): Set the column and the value of the column; when the column does not exist, an exception is reported -
df[Slice s]: Row slice selection data -
df.loc["index_label"]： Select data by row index label -
df.loc["index_label", "column_label"]： Select data by row and column labels -
df.iloc[0]： Index by row （row number） select data