5.22. DataFrame Slicing

import pandas as pd
import numpy as np
np.random.seed(0)

df = pd.DataFrame(
    columns = ['Morning', 'Noon', 'Evening', 'Midnight'],
    index = pd.date_range('1999-12-30', periods=7),
    data = np.random.randn(7, 4))

df
#              Morning      Noon   Evening  Midnight
# 1999-12-30  1.764052  0.400157  0.978738  2.240893
# 1999-12-31  1.867558 -0.977278  0.950088 -0.151357
# 2000-01-01 -0.103219  0.410599  0.144044  1.454274
# 2000-01-02  0.761038  0.121675  0.443863  0.333674
# 2000-01-03  1.494079 -0.205158  0.313068 -0.854096
# 2000-01-04 -2.552990  0.653619  0.864436 -0.742165
# 2000-01-05  2.269755 -1.454366  0.045759 -0.187184

5.22.1. Rows

5.22.1.1. Slicing by index

df[1:3]
#              Morning      Noon   Evening  Midnight
# 1999-12-31  1.867558 -0.977278  0.950088 -0.151357
# 2000-01-01 -0.103219  0.410599  0.144044  1.454274

5.22.2. Columns

5.22.2.1. Column range

df.loc[:, 'Morning':'Evening']
#              Morning      Noon   Evening
# 1999-12-30  1.764052  0.400157  0.978738
# 1999-12-31  1.867558 -0.977278  0.950088
# 2000-01-01 -0.103219  0.410599  0.144044
# 2000-01-02  0.761038  0.121675  0.443863
# 2000-01-03  1.494079 -0.205158  0.313068
# 2000-01-04 -2.552990  0.653619  0.864436
# 2000-01-05  2.269755 -1.454366  0.045759

5.22.3. Assignments

Todo

Create assignments