Must have latest software Office 365 XLSX and be able to properly format MCQ. Also if you do not have the correct most update office 365 do not bid cause you can’t do this work.ġ. We do not want to waste your time or ours we just want a bidder who knows and has the experience. What you should note before trying to even submit a bid that you can do this work, you should consider if you have never done this type of work, then maybe you should sit this one out and allow only an experienced person bid. This code essentially combines both files on the 'site' - 'code' column relationship, essentially ordering the 'id' column in the excel file to match that of the csv file, and then assigning it to the 'siteId' column of the csv file, and then saving this as a new file.PDF MCQ converted and reformatted to XLXS or CSV #Assign merged_file 'id' column to the original csv file's column 'siteId'Įxcel_file.to_excel('MTN_Updated.xlsx', index=False) Merged_file = excel_rge(csv_file, left_on='site', right_on='code', how='left') #Join files together base on the ID's given by the 'site' and 'code' columns I realised I had few things backwards with my old code, hopefully this provides you with what you're looking for, if not feel free to let me know what needs to be changed with it: #Read in Excel/CSV filesĬsv_file = pd.read_csv('csv_file.csv') #Change name to your csv file name I've edited my code to reflect the changes you require, from the photos provided.
Something like this (written in pseudo code): excel_file = (excel_file converted to csv_file based on matches with csv_file) I'm looking for a way to merge them to get this resulting excel file here (keeping all columns & rows from the original. Thank you.Įdit: I have this Excel here and this CSV here.
Please, can you help me find a way to automate this matching. Using these matching columns, I want to fill the 'siteId' column, of "MTN.xlsx" with the corresponding values from 'id' of the csv file Image snippet of csv file. The values of the 47th column named 'site', has many duplicate values, which all match to a single row in the 'code' column of the csv file. In the cvs file each 'code' column has one 'id' so every row has a unique 'id' value. I have a file "MTN.xlsx" that I got from a database (I think), and a csv file exported by the result of an sql request.
0 kommentar(er)
