How to correctly get a partial dataframe of rows and then save it to a csv?

Question

First I read a csv and then get a partial dataframe from it (row 12~14), and then save it to another csv.
However it has warning afterwards saying 'A value is trying to be set on a copy of a slice from a DataFrame'
How should I get a partial dataframe and save it to another csv correctly?

    df = pd.read_csv(filename)

    df_min_part = df.iloc[12:14, : ]
    df_min_part.to_csv(filename + '_min_part.csv')

I couldn't reproduce the warning. It might happen somewhere else. — Ynjxsjmh, Apr 14 '21 at 04:35

score 0 · Answer 1 · answered Apr 14 '21 at 04:32

0

Use pandas.DataFrame.copy() if you want to do operation on df_min_part later.

df_min_part = df.iloc[12:14, : ].copy()

answered Apr 14 '21 at 04:32

Ynjxsjmh

28,441
6
34
52

How to correctly get a partial dataframe of rows and then save it to a csv?

1 Answers1