Input missing values for blank responses to key questions

May 21, 2025, 2:17 PM

qualtrics_dataset_cleaned.xlsx

Missing file

Load the dataset

The dataset has been successfully loaded. It contains 51 columns, including Start Date, End Date, Response Type, Progress, and many others. The first few rows of the dataset have been displayed above.
If you have any specific questions or need further analysis on this dataset, feel free to ask!

Add a value of -88 to all blank rows for stood_out and character_impressions.

The blank values in the columns stood_out and character_impressions have been successfully replaced with -88. The first few rows of these columns are shown above.
If you have any more questions or need further assistance with this dataset, feel free to ask!

Add a value of -88 to all blank rows for identify_closed

The blank values in the column identify_closed have been successfully replaced with -88. The first few rows of this column are shown above.
If you have any more questions or need further assistance with this dataset, feel free to ask!

Add a value of -88 to all blank rows for involved_experiences , knew_feelings , knew_experiences , easily_identify , understand_perspective , found_interesting , found_memorable , reminded_of_myself , reminded_of_someone

The blank values in the specified columns (involved_experiences, knew_feelings, knew_experiences, easily_identify, understand_perspective, found_interesting, found_memorable, reminded_of_myself, reminded_of_someone) have been successfully replaced with -88. The first few rows of these columns are shown above.
If you have any more questions or need further assistance with this dataset, feel free to ask!

add a value of -88 to all blank rows for anyone_trustworthy

The blank values in the column anyone_trustworthy have been successfully replaced with -88. The first few rows of this column are shown above.
If you have any more questions or need further assistance with this dataset, feel free to ask!

add a value of -88 to all blank rows for competent , warm , authentic , fake , arrogant , likeable , approachable , authoritative , trustworthy

The blank values in the specified columns (competent, warm, authentic, fake, arrogant, likeable, approachable, authoritative, trustworthy) have been successfully replaced with -88. The first few rows of these columns are shown above.
If you have any more questions or need further assistance with this dataset, feel free to ask!

add a value of -88 to all blank rows for anyone_share_values , seemed_scientist , interest_full_film , geographic_place , self_geographic_place , science_proximity , ses_class , self_working_class

The blank values in the specified columns (anyone_share_values, seemed_scientist, interest_full_film, geographic_place, self_geographic_place, science_proximity, ses_class, self_working_class) have been successfully replaced with -88. The first few rows of these columns are shown above.
If you have any more questions or need further assistance with this dataset, feel free to ask!

save the new dataset as qualtrics_dataset_cleaned_2

Get started with Vizly