Question 1 of 30
A data scientist is working on a project that involves analyzing customer feedback data stored in a JSON format. The feedback includes various attributes such as customer ID, feedback text, rating, and timestamp. During the analysis, the data scientist encounters an issue where the ratings are being treated as strings instead of numerical values. What is the most effective approach to resolve this issue and ensure accurate analysis of the ratings?
Convert the rating strings to numerical values before performing any calculations or aggregations.
Ignore the ratings and focus solely on the feedback text for sentiment analysis.
Use the ratings as they are and apply string manipulation functions to analyze them.
Store the ratings in a separate database table to handle them independently from the JSON structure.

Preparing for Oracle Cloud Infrastructure 2024 Data Science Professional? Now land the interview.

73% of qualified candidates get rejected because of weak resumes. Build an ATS-optimized, recruiter-ready resume in under 5 minutes - free to start.

Build My Resume Free