Ronak Mutha ronakmutha

ronakmutha / df_sort_2.py

Created April 1, 2019 05:39

>>> df.sort_values(colname,ascending=False)

ronakmutha / df_sort_1.py

Created April 1, 2019 05:38

>>> df.sort_values(colname)

ronakmutha / df_access_by_col_3.py

Created April 1, 2019 05:36

>>> df[(df['vertical'] == 'B2B') & (df['year'] == 2009)]

ronakmutha / df_access_by_col_2.py

Created April 1, 2019 05:36

>>> df[(df['year'] == 2009)]

ronakmutha / df_access_by_col_1.py

Last active April 1, 2019 05:35

>>> df[(df['vertical'] == 'B2B')]

ronakmutha / dataframe_iloc.py

Created April 1, 2019 05:34

>>> df.loc[:5, ["name","vertical", "url"]]

ronakmutha / dataframe_loc.py

Created April 1, 2019 05:33

>>> df.loc[:5] #similar to df.head()

ronakmutha / without_query_dataframe_result.py

Created April 1, 2019 05:30

	>>> %timeit df[(df['vertical'] == 'B2B') & (df['year'] == 2009)]

	1.69 ms ± 57 µs per loop (mean ± std. dev. of 7 runs, 1000 loops each)

ronakmutha / with_query_dataframe_result.py

Created April 1, 2019 05:30

	>>> %timeit df.query("vertical == 'B2B' and year == 2009")

	875 µs ± 24.6 µs per loop (mean ± std. dev. of 7 runs, 1000 loops each)

ronakmutha / read_csv.py

Created April 1, 2019 05:26

	>>> df = pd.read_csv('companies.csv')
	>>> df.head()