
Selesai
Disiarkan
Dibayar semasa penghantaran
I’m holding one master Excel workbook that mixes three kinds of B2B records: • Category A – every key field is present • Category B – email is missing, website exists • Category C – neither email nor website Your job is to sort the rows into their proper groups, apply a bad-word filter, and hand back four clean workbooks. I will send you a custom list of words and phrases that must be removed or redacted from every column before the export. Please keep the filename convention exactly as follows and do not add extra columns: Deliverables - [login to view URL] - [login to view URL] - [login to view URL] - [login to view URL] (the full, cleaned set) No “Category” column is needed in any of the files. Feel free to use Excel, Power Query, Python (pandas), or any other reliable method—as long as the output opens flawlessly in Excel. Once done, return the four files and a brief note on the steps you used so I can reproduce the process later if needed.
ID Projek: 40294168
7 cadangan
Projek jarak jauh
Aktif 1 bulan yang lalu
Tetapkan bajet dan garis masa anda
Dapatkan bayaran untuk kerja anda
Tuliskan cadangan anda
Ianya percuma untuk mendaftar dan membida pekerjaan
7 pekerja bebas membida secara purata ₹5,379 INR untuk pekerjaan ini

I'll sort your records by the completeness criteria, strip out the flagged words/phrases, and deliver the four files exactly as specified. Quick turnaround let me know when you're ready to share the file and the redaction list.
₹2,500 INR dalam 1 hari
4.1
4.1

Hello, We will sort each row into Category A, B, or C based on presence of email and website, apply your supplied bad-word filter across all columns, and produce four clean Excel workbooks named exactly as you specified. Our team will not add any extra columns or a Category column, will redact or remove listed words and phrases, and will validate that each output file opens flawlessly in Excel. We will return the four files along with a note describing the tools and steps used so you can repeat the process later.
₹10,000 INR dalam 3 hari
3.9
3.9

I see you need a clear separation of your B2B records into three categories with specific cleaning rules, along with a combined, fully cleaned workbook. Managing this while preserving exact filenames and excluding an extra category column shows you want a neat, professional result. Your project requires sorting rows based on the presence or absence of key fields like email and website, filtering out unwanted words from every column, and delivering four Excel files that open perfectly. You also want a reproducible method explained for future use, which is crucial for maintaining data hygiene over time. I recently completed a similar task using Python’s pandas to clean and split a large dataset based on missing fields, applying custom filters to redact sensitive content before exporting clean Excel files. That experience will help me efficiently deliver your requested files with no extra columns, following your exact naming convention, and provide a clear summary of the process for you. I can complete this data cleaning and splitting within two days, ensuring accuracy and clarity. Let’s discuss the specifics so I can start organizing your data promptly.
₹1,650 INR dalam 7 hari
2.1
2.1

Hi! I’ll clean the Excel file, apply your bad-word filter, and split the data into Category A, B, C. Then I’ll deliver the 4 Excel files exactly as requested with a short note on the process. Looking forward to your file.
₹2,000 INR dalam 2 hari
1.7
1.7

Hi, We would like to grab this opportunity and will work till you get 100% satisfied with our work. We are an expert team which have many years of experience on Python, Data Processing, Excel, Web Scraping, Data Scraping, Data Visualization, Data Analysis, Data Management Lets connect in chat so that We discuss further. Regards
₹1,500 INR dalam 7 hari
0.0
0.0

Gurgaon, India
Ahli sejak Jul 4, 2025
₹12500-37500 INR
₹12500-37500 INR
₹37500-75000 INR
₹1500-12500 INR
₹12500-37500 INR
₹10000-20000 INR
$30-250 USD
₹12500-37500 INR
$1500-3000 USD
₹100-400 INR / jam
$10-30 AUD
$30-250 USD
$25-50 USD / jam
$30-250 USD
₹750-1250 INR / jam
$30-250 USD
$250-750 USD
$30-250 USD
₹12500-37500 INR
$10-30 CAD
€12-18 EUR / jam
$30-250 USD
$250-750 USD
₹1500-12500 INR
₹100-400 INR / jam