Distinct Values

Question

Hi I have data like below I want distinct values only of fields (Emp_1,Emp_2,Emp_3,Emp_4) i.e E01,E02,E03,E04 Customer Emp_1 Emp_2 Emp_3 Emp_4 001 E01 E02 002 E03 E04 E02 Thanks

Emily Foster · Answer

Based on the data you provided regarding distinct values of fields (Emp_1, Emp_2, Emp_3, Emp_4), it seems like you are looking to extract unique values from these fields. In your case, you are interested in obtaining E01, E02, E03, and E04 as the distinct values. To achieve this, you can utilize various programming or data analysis tools depending on the format of your data. For example, in Python, you can use pandas to read the data and extract unique values from each column. Here's a simple example snippet: import pandas as pd # Assuming your data is in a DataFrame named 'df' distinct_emp_1 = df['Emp_1'].unique() distinct_emp_2 = df['Emp_2'].unique() distinct_emp_3 = df['Emp_3'].unique() distinct_emp_4 = df['Emp_4'].unique() print("Distinct values of Emp_1:", distinct_emp_1) print("Distinct values of Emp_2:", distinct_emp_2) print("Distinct values of Emp_3:", distinct_emp_3) print("Distinct values of Emp_4:", distinct_emp_4) By running this code, you should be able to retrieve the unique values present in each of the Emp_1, Emp_2, Emp_3, and Emp_4 columns. If you have a specific tool or language in mind, feel free to mention it so I can tailor the solution accordingly. Let me know if you need further assistance or have any specific requirements!