Ben Chuanlong Du's Blog

It is never too late to learn.

Dataframe in JavaScript

Things on this page are fragmentary and immature notes/thoughts of the author. Please read with your own judgement!

https://github.com/data-forge/data-forge-ts

https://github.com/Gmousse/dataframe-js

https://arrow.apache.org/docs/js/

References

https://stackoverflow.com/questions/30610675/python-pandas-equivalent-in-javascript

Read Text File into a pandas DataFrame

Advanced Options

  1. The argument sep supports regular expression! For example,

     :::python
 df = pd.read_csv(file, sep+" +")

nrows: control the number of rows to read skiprows, skip blank lines (the default behavior)

namesarray-like, optional List of column names to use. If the file contains a header row, then you should explicitly pass header=0 to override the column names. Duplicates in this list are not allowed.

Understand Index in pandas

Comments

  1. There are multiple ways to update the index of a DataFrame or Series. First, you can assign a new Series or Index object to the index of a DataFrame or Series. Or you can use methods such as DataFrame.set_index or DataFrame.reset_index. DataFrame.reset_index resets the index of a DataFrame/Series to an integer index starting from 0. The old index is kept by default but can be dropped using the option drop=True