Using .loc with a column of values

Question

Suppose I have a slice of a column within a dataframe df where I want to replace float values with other float values. Only the values to replace are from another dataframe, `newdf.

I've tried using

df.loc[row index condition, [column to replace vals]] = newdf[column]

but for some reason the resulting values are all NaN. Why is this so?

Stefan · Accepted Answer · 2016-06-14 01:55:04Z

2

The value from newdf need to align with the index of df. If newdf has the exact number of values you want to insert, you can try using .values:

df.loc[row index condition, [column to replace vals]] = newdf[column].values

answered Jun 14, 2016 at 1:55

Stefan

43.1k13 gold badges80 silver badges84 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Lisle Over a year ago

.values was the trick! The slice is the exact same number of rows, but I could no longer merge on indices. Perfect, thank you!

Collectives™ on Stack Overflow

Using .loc with a column of values

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related