@Umesh,Yes you could union them to reconstruct the single table, but you first have to add the missing column back and the columns need to be in the same order (union simply concatenates the two tables without consideration of column ordering).Thanks...
Hi Umesh,If you want to completely ignore the null/empty values then you could simply filter before you do the groupBy, but are you wanting to keep those values?If you want to keep the null values and avoid the skew, you could try splitting the DataF...