Excel to CSV Question Catalog Transformation

  • Status: Closed
  • Præmier: €50
  • Modtagne indlæg: 27
  • Vinder: zferd

Konkurrence Instruktioner

I am looking for a data expert to help transform my Pdfs question catalog into a specific CSV format. The targeted CSV format is as follows: number;Filename;question;answer1;answer1correct;answer2;answer2correct;answer3;answer3correct;answer4;answer4correct.

- Purpose: The purpose of this project, namely, is to make the data compatible with a specific system.

- Assistance Required: Depending on the case, some data entries may need reformatting prior to transformation, ensuring they are structured correctly.

- Data Type: The 'question' and 'answer' columns contain mixed data, both textual and numerical.

Ideal Candidate Skills & Experience:
- Experience in data manipulation and transformation using Excel and CSV formats.
- Proficiency in data cleaning and standard standards application.
- Attention to detail to ensure entries are formatted correctly.

All Question has 2 - 4 answers with multiple right answers wich are marked by an X


The Excel i published is one of 4 Excel .. sum are 1400 questions

Anbefalede færdigheder

Arbejdsgiverfeedback

“excelent Work!”

Profilbillede BurgerA, Italy.

Bedste indlæg fra denne konkurrence

Se flere indlæg

Offentlig Præciserings Opslagstavle

  • EmadOwaida
    EmadOwaida
    • 1 måned siden

    Hello Contest holder, do you prefer each question along with related answers in one row!? Or you prefer each question in multi row based on answers numbers (4 rows) ?! (Please advise based on your new system requirement). Regards Emad

    • 1 måned siden
    1. EmadOwaida
      EmadOwaida
      • 1 måned siden

      #CONTEST HOLDER , even if you already choosed the winner, I'll appreciate if you please check and evaluate/Rate my Entry #24 And 5 tools created for your project. Regards Emad

      • 1 måned siden
    2. EmadOwaida
      EmadOwaida
      • 1 måned siden

      #CONTEST HOLDER , thanks a lot for your Rating. I really appreciate it ?

      • 1 måned siden
  • mailtoafaqCEO
    mailtoafaqCEO
    • 1 måned siden

    ???

    • 1 måned siden
  • rekoleksitaktara
    rekoleksitaktara
    • 1 måned siden

    hello sir, I have posted an example of the results of creating my CSV file in your link. you check at #22 by Rekoleksi Taktaradisi Laia. If you want to work with me, I am very happy to accept the job.

    • 1 måned siden
  • Amrghazal
    Amrghazal
    • 1 måned siden

    hello MR please check #21 is this like what you looking for ? thanks in advanced

    • 1 måned siden
  • chintanshah97
    chintanshah97
    • 1 måned siden

    Please check #7

    • 1 måned siden
    1. chintanshah97
      chintanshah97
      • 1 måned siden

      Sir! can you please share your feedback!

      • 1 måned siden
  • zferd
    zferd
    • 1 måned siden

    Also you said "All Question has 2 - 4 answers with multiple right answers wich are marked by an X". This is incorrect, there are questions with 5 and 6 answers or lines. Take for example question number 1080. Not only that number but there are others. How to proceed?

    • 1 måned siden
  • zferd
    zferd
    • 1 måned siden

    Another issue in xlsx, in question number 1479, the answer description is empty and it is marked as one of the correct answers. I believe this is incorrect. How to proceed?

    • 1 måned siden
  • TayyabDastgir
    TayyabDastgir
    • 1 måned siden

    out of four questions you want correct to be written in front of the answer where X is in column C, but what bout the one incorrect? Do you want to write incorrect or want to left it blank?

    • 1 måned siden
    1. BurgerA
      Konkurrenceafholder
      • 1 måned siden

      let it blank ! its ok

      • 1 måned siden
  • zferd
    zferd
    • 1 måned siden

    Parsing thru your xlsx file, I can see there are 6 answers or lines in question number 1166. And the word "vorgeschrieben" appears 3-times. Something is not right. The answer selections must be unique. How do we proceed?

    • 1 måned siden
    1. BurgerA
      Konkurrenceafholder
      • 1 måned siden

      it could be that the excel file has some error . possibile answers are 2-4 if there are more than 4 answers maybe the export of the answer was made in 2 ore more lines

      maybe i llpost a project with the original files

      • 1 måned siden
  • Farrukh Saeed
    Farrukh Saeed
    • 1 måned siden

    check #9

    • 1 måned siden

Vis flere kommentarer

Sådan kommer du i gang med konkurrencer

  • Opret din konkurrence

    Opret din konkurrence Hurtigt og nemt

  • Få tonsvis af indlæg

    Få tonsvis af indlæg Fra hele verden

  • Tildel det bedste indlæg

    Tildel det bedste indlæg Download filerne - Nemt!

Opret en Konkurrence Nu eller slut dig til os i dag!