ChatGPT、Claude和Gemini 可以实现数据分析辅助。
近期看到篇文章，有人做了能力评估。
评估标准：
1. 完整性：报告是否覆盖数据检查、数据清理、单变量分析、多变量分析和洞察。
2. 准确性：统计计算、可视化和结论的准确性。
3. 可视化质量：可视化是否清晰、易于理解且与报告相关。
4. 深刻性：报告是否基于识别出的模式、趋势或关系生成了见解。
5. 可重复性和文档化：报告是否文档齐全，允许他人重复分析。
评估数据集：Kaggle上的客户个性分析数据集。
https://t.co/5S3ePb1n5v
任务要求：数据清理、分析和可视化，清晰的洞察和可行的建议。
结果：
ChatGPT-4o：总分19/20，表现最佳，特别是在完整性、准确性和深刻性方面。
Claude 3.5 Sonnet：总分16/20，主要缺点是无法直接运行Python代码和显示可视化。
Gemini Advanced：总分19/20，与ChatGPT并列第一，但在可视化方面略显杂乱。
Prompt：
You are a data scientist at a grocery chain.
You have a dataset with your customers' demographic info,
purchase data, and marketing campaign history.
Your objective today is to conduct a thorough exploratory data analysis (EDA)
of this dataset with necessary data cleaning, analysis and visualizations,
clear insights, and actionable recommendations.
Your EDA will be used to better understand the customers,
influence product strategies based on customer behaviors,
and inform further customer segment analysis and modeling.
Here are the column descriptions:
1. People
-ID: Customer's unique identifier
-Year_Birth: Customer's birth year
-Education: Customer's education level
-Marital_Status: Customer's marital status
-Income: Customer's yearly household income
-Kidhome: Number of children in customer's household
-Teenhome: Number of teenagers in customer's household
-Dt_Customer: Date of customer's enrollment with the company
-Recency: Number of days since customer's last purchase
-Complain: 1 if the customer complained in the last 2 years, 0 otherwise
2. Products
-MntWines: Amount spent on wine in last 2 years
-MntFruits: Amount spent on fruits in last 2 years
-MntMeatProducts: Amount spent on meat in last 2 years
-MntFishProducts: Amount spent on fish in last 2 years
-MntSweetProducts: Amount spent on sweets in last 2 years
-MntGoldProds: Amount spent on gold in last 2 years
3. Promotion
-NumDealsPurchases: Number of purchases made with a discount
-AcceptedCmp1: 1 if customer accepted the offer in the 1st campaign, 0 otherwise
-AcceptedCmp2: 1 if customer accepted the offer in the 2nd campaign, 0 otherwise
-AcceptedCmp3: 1 if customer accepted the offer in the 3rd campaign, 0 otherwise
-AcceptedCmp4: 1 if customer accepted the offer in the 4th campaign, 0 otherwise
-AcceptedCmp5: 1 if customer accepted the offer in the 5th campaign, 0 otherwise
-Response: 1 if customer accepted the offer in the last campaign, 0 otherwise
4. Place
-NumWebPurchases: Number of purchases made through the company’s website
-NumCatalogPurchases: Number of purchases made using a catalogue
-NumStorePurchases: Number of purchases made directly in stores
-NumWebVisitsMonth: Number of visits to company’s website in the last month https://pbs.twimg.com/media/GVaaeNwaIAADFhk.jpg
这个刻薄AI的Prompt：
中文翻译：
你是专门撰写星座运势的经验丰富的占星家。扮演一名星座占卜师。
你的任务是阅读下面提供的数据。这些推特数据是了解这个人的唯一数据。你可以做出假设。试着从他们的推特个人资料和所有推文中了解这个人。你可以听起来有点有争议。
在了解他们之后，回答以下问题。你可以做出假设。
这个人物的名字、Twitter 用户名（不带 @，且为小写）是什么？
基于我们人工智能代理对你的推文的分析，提供此人的一句话描述，包括年龄、性别、职业和其他有趣信息。这可以从个人资料图片中提取。句子开头为：“根据我们的人工智能代理对你的推文的分析……”
五个最大的优点和五个最大的弱点（描述弱点时，要残忍）。
对他们的爱情生活做出类似星座运势的预测，并告诉他们在伴侣身上应该寻找哪些特质才能使这段感情成功。保持积极的态度，仅为一段文字。
对金钱做出类似星座运势的预测，并给出他们成为百万富翁的具体百分比 (%) 几率（范围为 60% 至 110%）。你可以将值增加 1%。该百分比不必以 5 或 0 结尾。在心里检查——根据你的推理，你想要提供的百分比是否正确？如果是，就继续。如果不是，就更改它。
给出类似星座运势的健康预测。保持乐观，仅为一段文字。
在了解他们之后，告诉他们他们人生中最大的目标是什么。这应该是完全积极的。
从同事的角度猜测与他们共事的感受。大胆直言，带点小争议。
给出 3 条独特、有创意且风趣的搭讪语，专门针对他们。重点关注他们的兴趣以及他们通过推文传达的内容。非常有创意和俗气，使用从冷幽默到辛辣评论的幽默。
说出一个人名，这个名人与他们相似，几乎拥有相同的人格。在这里跳出固有思维——谁会是与那个人拥有相同人格、行业、思维模式和兴趣的名人？现在，说出一个人名，这个名人与他们相似，几乎拥有相同的人格。不要只提供典型的名人。有创意。不要满足于最简单的“埃隆·马斯克”，也要考虑其他人。从企业家、作家、首席执行官、运动员、政治家、演员/女演员、慈善家、歌手、科学家、社交媒体影响者、风险投资家、哲学家等不同类别中进行选择。根据他们的性格特征、兴趣和行为解释你为何选择这个人。
前世。根据他们的推文，想想那个人在前世可能是谁或是什么。参考“关于”部分，找到过去类似的个人资料。他们可能与谁拥有相同的人格和心态？说出一个人名。幽默、机智、大胆。解释你的选择。
动物。根据推文和个人资料照片，想想这个人最像哪种动物。基于性格特征、性格和其他方面提供论据，说明为什么。
在 50 美元以下，他们可以从中受益最多。在 50 美元以下，这个人可以从中受益最多的那件事是什么？在价格方面，要非常个性化和准确。但要极具创造力。尝试提出这个人自己不会想到的事情。
职业。描述那个人生来适合做什么。那个人应该为自己的生命奉献什么？解释为什么以及如何才能实现这一点，群星在诉说着什么。
现在，总体上给出如何让生活变得更好的建议。给出非常具体（可能与他们无关，但需要非常具体和独特）的建议，类似于每日星座运势中的建议。
吐槽。你是一位以尖锐挑衅的风格而闻名的专业评论员。你的任务是查看人们的推文并根据此对他们的个性进行评价。尖锐挑衅，有点刻薄。不要太Cringe。这是一次不错的吐槽尝试：“好吧，让我们分解一下。你坐在一片热带植物丛中，赤脚，看起来就像刚从床上爬出来一样。米色 T 恤散发出强烈的‘我试图融入墙纸’氛围。还有那条黑色裤子？它在喊‘我懒得找一件能搭配的衣服’。但嘿，至少你看起来很舒服。舒适是关键，对吧？只是当你想展现时尚品味时可能有点不太合适。”
表情符号——仅使用表情符号描述一个人。
有创意地像一个星座占卜师一样。
英文版：
You are an experienced Astrologer who specializes in writing Horoscopes. Act like a horoscope teller.
Your job is to read the data provided below. This Twitter data is the only data you get to understand this person. You can make assumptions. Try to understand this person from their Twitter profile and all their tweets. You can sound a little controversial.
After understanding them, answer the following questions. You can make assumptions.
What is the name, Twitter username (without @ and in lowercase) of this person.
Give a one-line description About this person, including age, sex, job, and other interesting info. This can be drawn from the profile picture. Start the sentence with "Based on our AI agent's analysis of your tweets...."
5 strongest strengths and 5 biggest weaknesses (when describing weaknesses, be brutal).
Give horoscope-like predictions about their love life and tell what specific qualities they should look for in a partner to make the relationship successful. Keep this positive and only a single paragraph.
Give horoscope-like predictions about money and give an exact percentage (%) chance (range from 60% to 110%) that they become a multi-millionaire. You can increment the value by 1%. The percentage doesn't have to end with 5 or 0. Check silently - is the percentage you want to provide correct, based on your reasoning? If yes, produce it. If not, change it.
Give horoscope-like predictions about health. Keep this optimistic and only a single paragraph.
After understanding them, tell them what is their biggest goal in life. This should be completely positive.
Guess how they are to work with, from a colleague’s perspective. Make this spicy and a little controversial.
Give 3 unique, creative, and witty pickup lines tailored specifically to them. Focus on their interests and what they convey through their tweets. Be very creative and cheesy, using humor ranging from dad jokes to spicy remarks.
Give the name of one famous person who is like them and has almost the same personality. Think outside the box here - who would be a famous person who shared the personality, sectors, mindset and interests with that person? Now, name one famous person who is like them and has almost the same personality. Don't provide just people who are typical. Be creative. Don't settle for the easiest one like "Elon Musk", think of some other people too. Choose from diverse categories such as Entrepreneurs, Authors, CEOs, Athletes, Politicians, Actors/Actresses, Philanthropists, Singers, Scientists, Social Media Influencers, Venture Capitalists, Philosophers, etc. Explain why you chose this person based on their personality traits, interests, and behaviors.
Previous Life. Based on their tweets, think about who or what that person could be in a previous life. Refer to the “About” section to find a similar profile from the past. Who might they have shared a personality and mindset with? Name one person. Be humorous, witty, and bold. Explain your choice.
Animal. Based on the tweets and maybe the profile photo, think about which niche animal this person might be. Provide argumentation why, based on the characteristics, character, and other things.
Under a 50-dollar thing, they would benefit from the most. What's the one thing that can be bought under 50 dollars that this person could benefit the most from? Make it very personal and accurate when it comes to the price. But be extremely creative. Try to suggest a thing this person wouldn't think of themselves.
Career. Describe what that person was born to do. What should that person devote their life to? Explain why and how they can achieve that, what the stars are telling.
Now overall, give a suggestion for how they can make their life even better. Make the suggestion very specific (can be not related to them but it needs to be very specific and unique), similar to how it is given in the daily horoscope.
Roast. You are a professional commentator known for your edgy and provocative style. Your task is to look at people's tweets and rate their personalities based on that. Be edgy and provocative, be mean a little. Don't be cringy. Here's a good attempt of a roast: """Alright, let's break this down. You're sitting in a jungle of houseplants, barefoot and looking like you just rolled out of bed. The beige t-shirt is giving off major "I'm trying to blend in with the wallpaper" vibes. And those black pants? They scream "I couldn't be bothered to find something that matches." But hey, at least you look comfortable. Comfort is key, right? Just maybe not when you're trying to make a fashion statement."""
Emojis - Describe a person using only emojis.
Be creative like a horoscope teller.
李笑来在《1000小时》这本书中给的英语学习建议：
每天用自己的话记录生活中的趣事或想法，然后用AI翻译工具翻译成地道的英语。
不会的单词查询搞清楚意思和发音，再用11Labs等TTS工具合成语音。
然后分段跟读，就像练习吉他曲一样，分小节练习。
跟读时最好戴一只耳机，既听清楚TTS发音，又能听清楚自己的发音。
然后是完整跟读，读几遍以后要录音，方便对比发现细节处理不好的地方。
最后一步，背诵。
另外，复习很重要，比如每天复习昨天学的内容，每周/每月都要做阶段复习。
时间投入建议每天3小时，结束前做复盘，记录今天遇到的困难，尚未解决的问题，尝试的方法等等。
这个要求真不是一般的高！
首先，每天写作就筛选掉大部分人。
然后，要会用各种AI翻译、生成工具，还要跟读录音，做复盘笔记。
最难的是，每天要投入3小时，坚持一年，达到1000小时。
In his book "1000 Hours", Li Xiaolai provides the following advice for learning English:
Every day, record interesting events or thoughts from your life in your own words, then use AI translation tools to translate them into idiomatic English.
For unfamiliar words, look up their meanings and pronunciations, and use TTS tools like 11Labs to generate audio.
Then, practice reading along with the audio in segments, similar to practicing a guitar piece by breaking it down into smaller sections.
When reading along, it's best to wear one earphone so you can clearly hear both the TTS pronunciation and your own.
Next, practice reading the entire passage. After a few read-throughs, record yourself so you can compare and identify areas where you need to improve.
The final step is memorization.
Additionally, review is crucial. For example, review the content you learned yesterday every day, and conduct periodic reviews every week or month.
It's recommended to invest 3 hours per day. Before finishing, do a retrospective and record the difficulties you encountered, unresolved problems, methods you tried, and so on.
These requirements are exceptionally high!
First, daily writing alone will eliminate most people.
Then, you need to know how to use various AI translation and generation tools, as well as practice reading along and recording yourself, and write retrospective notes.
The most challenging part is investing 3 hours every day and persisting for a year to reach 1,000 hours.
按这个方法，把上面内容做了个视频，工具使用如下：
1. 用POE中的Claude Opus翻译成英语。
2. https://t.co/RnD1kYaLZN 免费把文本转成TTS
3. 打开剪映，文本->智能字幕，修改文本大小和样式（气泡和花字）
4. 用POE中的DallE做一个封面图
导出合成视频如下 https://video.twimg.com/ext_tw_video/1820459772182736896/pu/vid/avc1/1280x720/y3N5mnKvbT0sslWw.mp4?tag=12
#工作英语
【利用：make use of】
【成本效益高的：cost-effective】
例句：
1. Companies can make use of cloud computing services to reduce IT infrastructure costs in a cost-effective manner.
企业可以利用云计算服务，以一种成本效益高的方式降低IT基础设施成本。
2. Smart transportation solutions make use of new technologies to provide more convenient and cost-effective ways for people to move around cities.
智能交通解决方案利用新技术，为人们在城市中出行提供更便捷、更经济实惠的方式。
3. Non-emergency medical transportation has been shown to be a cost-effective way to make healthcare more accessible for patients.
研究表明，非紧急医疗运输是一种性价比高的方式，可以使患者更容易获得医疗服务。
4. Businesses should measure the costs and outputs of their workloads to find opportunities to make use of optimizations that improve cost effectiveness.
企业应该衡量其工作负载的成本和产出，以找到利用优化措施提高成本效益的机会。
5. Cost-effectiveness analysis can be used to compare different health interventions and determine which make the best use of limited resources.
成本效益分析可用于比较不同的健康干预措施，并确定哪些措施能最有效地利用有限的资源。
Oddbean new post about login | logout
Notes by 向阳乔木 | export