Merging two files with same headers

[Thirumalai Raj R]

Hi

I'm new to python and facing a difficulty in merging two files.

I have two excel files with same headers. Values present in one row cell may not be available in the same cell in the next file.

For instance, 

FileA - A18 = lambo    FileB - A18 = <blank>

FileA - A19 = <blank> FileB - A19 = ferrari

After merging, I want 

FinalNew -A18 = Lambo

FinalNew -A19 = ferrari

Help me out in this pls. TIA

Regards,

Thirumalai Raj, R.

[Dan Bareket]

https://stackoverflow.com/questions/38152389/coalesce-values-from-2-columns-into-a-single-column-in-a-pandas-dataframe

--
You received this message because you are subscribed to the Google Groups "PyData" group.
To unsubscribe from this group and stop receiving emails from it, send an email to pydata+un...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.