I have a dataset, where some of the columns are null I have to fill the data which is above
Example:
name | last name | location | date | rate | price | code | ad id |
adam | smith | LN | 2020-12-01 | 0.21 | 547 | 785 | 456 |
2020-12-02 | 475 | ||||||
2020-12-03 | 478 | ||||||
Kelly | cuco | USA | 2020-12-04 | 0.25 | 478 | 745 | 712 |
Eve | kane | UK | 2020-12-05 | 0.14 | 5214 | 241 | 358 |
2020-12-06 | 547 | ||||||
jake | rom | IK | 2020-12-07 | 0.54 | 475 | 145 | 254 |
if you will see the name, last name, location, rate, code, and ad id have a null value below So I have to change it with whatever I have above
and date and price will never be null
Output"
name | last name | location | date | rate | price | code | ad id |
adam | smith | LN | 2020-12-01 | 0.21 | 547 | 785 | 456 |
adam | smith | LN | 2020-12-02 | 0.21 | 475 | 785 | 456 |
adam | smith | LN | 2020-12-03 | 0.21 | 478 | 785 | 456 |
Kelly | cuco | USA | 2020-12-04 | 0.25 | 478 | 745 | 712 |
Eve | kane | UK | 2020-12-05 | 0.14 | 5214 | 241 | 358 |
Eve | kane | UK | 2020-12-06 | 0.14 | 547 | 241 | 358 |
jake | rom | IK | 2020-12-07 | 0.54 | 475 | 145 | 254 |