MilesDowe/fill_missing_col.py

Created April 20, 2023 19:53

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/MilesDowe/d057b2e8d26d52d437b2adbc23f72f58.js"></script>
Save MilesDowe/d057b2e8d26d52d437b2adbc23f72f58 to your computer and use it in GitHub Desktop.

Download ZIP

Simple way to update a column of a DF using values from another, similar DF.

Raw

fill_missing_col.py

	bad = bad.set_index('KeyCol').MissingCol.dropna()
	good.fillna(good.drop('MissingCol', 1).join(bad, on='KeyCol'))

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment