Skip to content

Latest commit

 

History

History
executable file
·
493 lines (472 loc) · 17.5 KB

output-csv.md

File metadata and controls

executable file
·
493 lines (472 loc) · 17.5 KB
copyright lastupdated subcollection
years
2015, 2019
2019-03-07
personality-insights

{:shortdesc: .shortdesc} {:new_window: target="_blank"} {:tip: .tip} {:important: .important} {:note: .note} {:deprecated: .deprecated} {:pre: .pre} {:codeblock: .codeblock} {:screen: .screen} {:javascript: .ph data-hd-programlang='javascript'} {:java: .ph data-hd-programlang='java'} {:python: .ph data-hd-programlang='python'} {:swift: .ph data-hd-programlang='swift'}

Understanding a CSV profile

{: #outputCSV}

The service returns the results of its analysis in comma-separated values (CSV) format when you specify text/csv with the Accept header of a request. CSV output provides information that is similar to the information provided by JSON output. As with JSON, the information in the CSV output depends on whether the input data is timestamped and whether you request raw scores and consumption preferences. {: shortdesc}

CSV output, unlike JSON, is returned as a fixed number of columns. The first row of the output consists of optional column labels, which are included only if you set the csv_headers query parameter of the request to true. The second row of the output, which is always present, contains the results of the analysis.

The following sections list and briefly describe all columns of the CSV output in the exact order in which they appear in the results. The tables describe the columns by logical grouping, including the number of columns in each group and their optional labels. Other than the word count, all numeric data is returned as double values.

For more information about the meaning of the CSV columns, see Understanding a JSON profile and Interpreting the numeric results.

Basic characteristics and metadata

{: #basicCSV}

The following columns are always present in the CSV output for all requests.

Table 1. CSV columns for basic characteristics and metadata
Grouping
(Number of columns)
Optional labels Description
Big Five Agreeableness percentiles
(Seven columns)
big5_agreeableness
facet_altruism
facet_cooperation
facet_modesty
facet_morality
facet_sympathy
facet_trust
Normalized percentile score for the author of the text for the named dimension or facet.
Big Five Conscientiousness percentiles
(Seven columns)
big5_conscientiousness
facet_achievement_striving
facet_cautiousness
facet_dutifulness
facet_orderliness
facet_self_discipline
facet_self_efficacy
Normalized percentile score for the author of the text for the named dimension or facet.
Big Five Extraversion percentiles
(Seven columns)
big5_extraversion
facet_activity_level
facet_assertiveness
facet_cheerfulness
facet_excitement_seeking
facet_friendliness
facet_gregariousness
Normalized percentile score for the author of the text for the named dimension or facet.
Big Five Emotional range percentiles
(Seven columns)
big5_neuroticism
facet_anger
facet_anxiety
facet_depression
facet_immoderation
facet_self_consciousness
facet_vulnerability
Normalized percentile score for the author of the text for the named dimension or facet.
Big Five Openness percentiles
(Seven columns)
big5_openness
facet_adventurousness
facet_artistic_interests
facet_emotionality
facet_imagination
facet_intellect
facet_liberalism
Normalized percentile score for the author of the text for the named dimension or facet.
Needs percentiles
(Twelve columns)
need_liberty
need_ideal
need_love
need_practicality
need_self_expression
need_stability
need_structure
need_challenge
need_closeness
need_curiosity
need_excitement
need_harmony
Normalized percentile score for the author of the text for the named need.
Values percentiles
(Five columns)
value_conservation
value_hedonism
value_openness_to_change
value_self_enhancement
value_self_transcendence
Normalized percentile score for the author of the text for the named value.
Days of the week percentages
(Seven columns)
behavior_sunday
behavior_monday
behavior_tuesday
behavior_wednesday
behavior_thursday
behavior_friday
behavior_saturday
If the input text is timestamped, the percentage of the input that is associated with each day of the week. Otherwise, all percentages are 0.0.
Hours of the day percentages
(Twenty-four columns)
behavior_0000 through behavior_2300 If the input text is timestamped, the percentage of the input that is associated with each hour of the day. Otherwise, all percentages are 0.0.
Word count and language
(Two columns)
word_count
processed_language
An integer that indicates the number of words present in the input text, and a two-letter identifier for the language model that the service used to analyze the text.

Raw scores

{: #rawCSV}

The following columns are present only if you request raw scores by setting the raw_scores query parameter to true. In all cases, the column is a double value that provides the author's raw score for the dimension, facet, need, or value.

Table 2. CSV columns for raw scores
Grouping
(Number of columns)
Optional labels
Big Five Agreeableness raw scores
(Seven columns)
big5_agreeableness_raw
facet_altruism_raw
facet_cooperation_raw
facet_modesty_raw
facet_morality_raw
facet_sympathy_raw
facet_trust_raw
Big Five Conscientiousness raw scores
(Seven columns)
big5_conscientiousness_raw
facet_achievement_striving_raw
facet_cautiousness_raw
facet_dutifulness_raw
facet_orderliness_raw
facet_self_discipline_raw
facet_self_efficacy_raw
Big Five Extraversion raw scores
(Seven columns)
big5_extraversion_raw
facet_activity_level_raw
facet_assertiveness_raw
facet_cheerfulness_raw
facet_excitement_seeking_raw
facet_friendliness_raw
facet_gregariousness_raw
Big Five Emotional range raw scores
(Seven columns)
big5_neuroticism_raw
facet_anger_raw
facet_anxiety_raw
facet_depression_raw
facet_immoderation_raw
facet_self_consciousness_raw
facet_vulnerability_raw
Big Five Openness raw scores
(Seven columns)
big5_openness_raw
facet_adventurousness_raw
facet_artistic_interests_raw
facet_emotionality_raw
facet_imagination_raw
facet_intellect_raw
facet_liberalism_raw
Needs raw scores
(Twelve columns)
need_liberty_raw
need_ideal_raw
need_love_raw
need_practicality_raw
need_self_expression_raw
need_stability_raw
need_structure_raw
need_challenge_raw
need_closeness_raw
need_curiosity_raw
need_excitement_raw
need_harmony_raw
Values raw scores
(Five columns)
value_conservation_raw
value_hedonism_raw
value_openness_to_change_raw
value_self_enhancement_raw
value_self_transcendence_raw

Significance

{: #significantCSV}

The following columns are always present in the CSV output for all requests. In all cases, the column is a boolean value that indicates whether the dimension, facet, need, or value is meaningful for the processed input language.

Table 3. CSV columns for significance
Grouping
(Number of columns)
Optional labels
Big Five Agreeableness significance
(Seven columns)
big5_agreeableness_significant
facet_altruism_significant
facet_cooperation_significant
facet_modesty_significant
facet_morality_significant
facet_sympathy_significant
facet_trust_significant
Big Five Conscientiousness significance
(Seven columns)
big5_conscientiousness_significant
facet_achievement_striving_significant
facet_cautiousness_significant
facet_dutifulness_significant
facet_orderliness_significant
facet_self_discipline_significant
facet_self_efficacy_significant
Big Five Extraversion significance
(Seven columns)
big5_extraversion_significant
facet_activity_level_significant
facet_assertiveness_significant
facet_cheerfulness_significant
facet_excitement_seeking_significant
facet_friendliness_significant
facet_gregariousness_significant
Big Five Emotional range significance
(Seven columns)
big5_neuroticism_significant
facet_anger_significant
facet_anxiety_significant
facet_depression_significant
facet_immoderation_significant
facet_self_consciousness_significant
facet_vulnerability_significant
Big Five Openness significance
(Seven columns)
big5_openness_significant
facet_adventurousness_significant
facet_artistic_interests_significant
facet_emotionality_significant
facet_imagination_significant
facet_intellect_significant
facet_liberalism_significant
Needs raw significance
(Twelve columns)
need_liberty_significant
need_ideal_significant
need_love_significant
need_practicality_significant
need_self_expression_significant
need_stability_significant
need_structure_significant
need_challenge_significant
need_closeness_significant
need_curiosity_significant
need_excitement_significant
need_harmony_significant
Values significance
(Five columns)
value_conservation_significant
value_hedonism_significant
value_openness_to_change_significant
value_self_enhancement_significant
value_self_transcendence_significant

Consumption preferences

{: #preferenceCSV}

The following columns are present only if you request consumption preferences by setting the consumption_preferences query parameter to true. In all cases, the column is a double value that reports the likelihood that the author prefers the named consumption topic.

Table 4. CSV columns for consumption preferences
Grouping
(Number of columns)
Optional labels
Purchasing preferences category scores
(Twelve columns)
consumption_preferences_spur_of_moment
consumption_preferences_credit_card_payment
consumption_preferences_influence_brand_name
consumption_preferences_influence_utility
consumption_preferences_online_ads
consumption_preferences_social_media
consumption_preferences_family_members
consumption_preferences_clothes_quality
consumption_preferences_clothes_style
consumption_preferences_clothes_comfort
consumption_preferences_automobile_ownership_cost
consumption_preferences_automobile_safety
Music preferences category scores
(Nine columns)
consumption_preferences_music_rap
consumption_preferences_music_country
consumption_preferences_music_r_b
consumption_preferences_music_hip_hop
consumption_preferences_music_live_event
consumption_preferences_music_playing
consumption_preferences_music_latin
consumption_preferences_music_rock
consumption_preferences_music_classical
Health and activity preferences category scores
(Three columns)
consumption_preferences_gym_membership
consumption_preferences_outdoor
consumption_preferences_eat_out
Movie preferences category scores
(Ten columns)
consumption_preferences_movie_romance
consumption_preferences_movie_adventure
consumption_preferences_movie_horror
consumption_preferences_movie_musical
consumption_preferences_movie_historical
consumption_preferences_movie_science_fiction
consumption_preferences_movie_war
consumption_preferences_movie_drama
consumption_preferences_movie_action
consumption_preferences_movie_documentary
Reading preferences category scores
(Five columns)
consumption_preferences_read_frequency
consumption_preferences_books_entertainment_magazines
consumption_preferences_books_non_fiction
consumption_preferences_books_financial_investing
consumption_preferences_books_autobiographies
Volunteering preferences category scores
(One column)
consumption_preferences_volunteer
Environmental concern preferences category scores
(One column)
consumption_preferences_concerned_environment
Entrepreneurship preferences category scores
(One column)
consumption_preferences_start_business