An independent mind...

Data Science Manager at Hospital IQ – Planet discoverer, researcher, developer, geek.

Pandas: Groupby Not As Index

less than 1 minute read

Let’s consider the following DataFrame:

less than 1 minute read

```python df = pd.DataFrame(np.random.randn(10,3),columns=list(‘ABC’))

less than 1 minute read

df.groupby('Sp').apply(lambda t: t[t.Count==t.Count.max()])

less than 1 minute read

pandas’ DateOffset represents a regular frequency increment:

less than 1 minute read

The count() method returns the number of non-NaN values in each column. Similarly, count(axis=1) returns the number of non-NaN values in each row.