How to remove nan value while combining two column in Panda Data frame?

by

You can use combine_first or fillna:

print df['feedback_id'].combine_first(df['_id'])
0    568a8c25cac4991645c287ac
1    568df45b177e30c6487d3603
2    568df434832b090048f34974
3    568cd22e9e82dfc166d7dff1
4    568df3f0832b090048f34711
5    568e5a38b4a797c664143dda
Name: feedback_id, dtype: object

print df['feedback_id'].fillna(df['_id'])
0    568a8c25cac4991645c287ac
1    568df45b177e30c6487d3603
2    568df434832b090048f34974
3    568cd22e9e82dfc166d7dff1
4    568df3f0832b090048f34711
5    568e5a38b4a797c664143dda
Name: feedback_id, dtype: object

More Related Contents:

  1. Filter dataframe rows if value in column is in a set list of values [duplicate]
  2. Converting a Pandas GroupBy output from Series to DataFrame
  3. datetime dtypes in pandas read_csv
  4. Split a large pandas dataframe
  5. Insert a row to pandas dataframe
  6. Convert unix time to readable date in pandas dataframe
  7. Is it possible to insert a row at an arbitrary position in a dataframe using pandas?
  8. Python Pandas Counting the Occurrences of a Specific value
  9. What is the point of indexing in pandas?
  10. How to keep index when using pandas merge
  11. Add column with constant value to pandas dataframe [duplicate]
  12. What is the difference between pandas.qcut and pandas.cut?
  13. pandas dataframe columns scaling with sklearn
  14. Mapping columns from one dataframe to another to create a new column [duplicate]
  15. pivot_table No numeric types to aggregate
  16. Unpack dictionary from Pandas Column
  17. Using Pandas Value_Counts and matplotlib
  18. which is faster for load: pickle or hdf5 in python
  19. Resample Daily Data to Monthly with Pandas (date formatting)
  20. Saving plots (AxesSubPlot) generated from python pandas with matplotlib’s savefig
  21. Set order of columns in pandas dataframe
  22. Python Pandas – Merge based on substring in string
  23. How to show a pandas dataframe into a existing flask html table?
  24. Merging two dataframes based on a date between two other dates without a common column
  25. How to update Pandas from Anaconda and is it possible to use eclipse with this last
  26. What is the fastest way to output large DataFrame into a CSV file?
  27. Using pandas crosstab to create a bar plot
  28. Expand pandas DataFrame column into multiple rows
  29. Using regex matched groups in pandas dataframe replace function
  30. How to get number of groups in a groupby object in pandas?

Leave a Comment