Hope you can see such output from this code
import re for i in range(Data_list.shape[0]): #iterate over rows for j in range(Data_list.shape[1]): #iterate over columns if ((i ==0) & (j ==0)): heading = re.sub(r'[^\x00-\x7f]',r'', Data_list.at[i, j]) #get cell value print(heading, end="\n") else: if pd.notnull(Data_list.at[i, j]): data = re.sub(r'[^\x00-\x7f]',r'', Data_list.at[i, j]) #get cell value print(data, end=", ")
Output:Comments & Equip. Transfers
Drilling good ground all shift, 2 x Gyro Surveys, Mixing muds to condition the hole, Driller travelled home for shift change at end of shift, Equipment onsite=,