New Match Value in new column

[sinoyon780]

Hi,

Column A in primary key match with Column B And Column B And C save Valu but in C not same sequence so i want new Id list from column A to D basee on ccolumn C sequence.

thank you.

 

[sinoyon780]

Here is the Python solution i have done>

import pandas as pd

# Read the Excel file with 'Id' column as string
df = pd.read_excel("/content/SHARP_EmployeeID.xlsx", dtype={'Id': str})

# Display the DataFrame to verify the data
print(df.head())

# Drop duplicates in 'PersonalNo' column to make it unique
df_unique_personalno = df.drop_duplicates('PersonalNo')

# Create a dictionary mapping PersonalNo to Id
personalno_to_id = df_unique_personalno.set_index('PersonalNo')['Id'].to_dict()

# Use map to create Id2 based on EmployeeId sequence
df['Id2'] = df['EmployeeId'].map(personalno_to_id)
df['Id2'] = df['Id2'].astype(str)
# Print or save the DataFrame with the new column

print(df)

#Save to new excel file
df.to_excel("output_file.xlsx", index=False)