(TIL) Pandas: Speed up merges
You can improve the speed of a merge by first specifying the key column of the merge as the index of your dataframes, and then using join instead of merge:
Recent Posts
(TIL) Pandas: Get Memory usage of DataFrame with info
The memory usage of a DataFrame (including the index) is shown when accessing the info method of a DataFrame. A configuration option, display.memory_usage, s...
(TIL) Pandas: Groupby Not As Index
Let’s consider the following DataFrame:
(TIL) Pandas: Iterating through groups
```python df = pd.DataFrame(np.random.randn(10,3),columns=list(‘ABC’))
(TIL) Pandas: Get rows with max value of group
df.groupby('Sp').apply(lambda t: t[t.Count==t.Count.max()])