跟读练习: How I use ChatGPT as a Data Analyst - 通过视频学习英语口语
选择练习模式
每种模式都会打开全屏练习室。
196 句
如果句子过短或过长,请点击 Edit 进行调整。
1
Data nerds!
2
I've been using ChatGPT to analyze data for my job.
3
And it's been saving me a lot of time.
4
Let me show you what I mean.
5
So here we have a spreadsheet with some data we want to analyze.
6
First, I asked it to connect to the data by providing it with a link to the spreadsheet.
7
It gives me the first few reads of the data so I know it's connected.
8
So next, I ask it, what's this dataset even about?
9
And it looks like it's a bunch of job postings specifically for the role of data analyst.
10
It even provides some basic stats about the columns in the spreadsheet.
11
Let's do some quick EDA to see what are the 10 most common jobs.
12
And it provides me this bar graph with data analyst as the most common job title, followed by senior data analysts.
13
Let's wrap this analysis up and check out what the median salary is for these 10 most common jobs.
14
With this calculation, let's actually time it.
15
And in just over a minute, we're able to generate both these visualizations.
16
You can see that data scientists have some of the highest, while data analysts have some of the lowest.
17
I don't like this.
18
So I did this entire analysis before filming this without ChatGPT, and it took me almost an hour.
19
And here, in less than a few minutes, we've generated all of these different visualizations and insights without even coding one bit.
20
Now that we've shown ChatGPT's capabilities, let's move on to an even bigger problem that we're going to solve.
21
All right, so I stayed up a little bit too late last night.
22
How's my audio?
23
My audio good?
24
And I put together this PowerPoint of how we're going to solve this problem
25
and there's a lot of hype around AI lately
26
and whether it's going to actually automate and take away jobs and is it going to take over the world
27
probably but more importantly we want to focus on how is AI impacting data jobs
28
and we'll look at two main aspects first from the people's aspect from the person
29
that has the job how satisfied are they with AI impacting
30
their jobs the next one is businesses is there going to be an actual impact such as financial
31
or they're going to be actually be looking for those with skills of this AI
32
and how we're going to accomplish this all well here's the game plan
33
I have a two -step approach the first is using chat gpt for data research
34
we're going to be using different plugins
35
and internet searching methods in order to find research papers data whatever
36
it may be in order to find insights into those two main areas
37
that we're trying to look at from there we're going to move into data analysis
38
and we're going to once again use chat gpt to actually analyze this data
39
that we found in order to find insights and maybe prove one way
40
or another whether how bad ai is impacting data science jobs
41
but before we just dive into this analysis we need to understand the capabilities of this tool chat gbt
42
so um brb so what the heck is chat gpt well i asked it
43
and come to find out it's an artificial intelligence that's running on one of the models from OpenAI.
44
Specifically, this one right here, I'm using model GPT -4, which is their newest and greatest one.
45
And in a recent survey from Stack Overflow, over 50 ,000 respondents reported that they prefer ChatGPT over any other AI chatbot at the moment.
46
I've also tried all these other options and done a cold comparison video,
47
and I've found that ChatGPT is the best at performing data analysis at the moment.
48
But there is a catch with ChatGPT, and that comes to pricing.
49
So you can use the free version of ChatGPT and go in and prompt it and get different insights from it,
50
but you're really going to be limited in what you get.
51
Now, if you go with the pro version, not only do you have access to an improved model of GPT -4,
52
but also you have access to plugins.
53
And plugins are really the money.
54
Plugins allow these chatbots to connect to different applications.
55
So recently I've been using it with Wolfram in order to connect
56
and do analysis on the backend and then feed it back into ChatGPT so I can get my numbers crunched.
57
All right, enough with this green screen break.
58
Let's get back to the video.
59
All right, I made some progress on using ChatGPT to go
60
and search the internet to find things around AI impacting data science jobs.
61
And first up is one of the limitations that I found with ChatGPT,
62
and that's that the model itself was only trained on data up to September of 2021.
63
This has been a really big problem
64
because you can't actually ask the model directly about things that have happened right now because it won't know.
65
That's where plugins come in.
66
The first main one that I've been using to search the internet is their Bing plugin
67
that allows it to go in and search and find different articles, research papers, and publications, and I can find out what's most impacting.
68
Now, ChatGPT isn't really that great.
69
I also tested out
70
Bing and also the Google competitor, Bard, and they're not really search engines, right?
71
So I still rely on Google itself to go in and search, but I was able to find some recent articles on this,
72
specifically this one from McKinsey talking about the economic impact of generative AI.
73
Now this bad boy is almost a hundred pages long.
74
And if you think I'm going to go through and read it, you're probably wrong.
75
So what's good about ChatGPT is they have plugins in order to read these type of PDFs.
76
I just give it the link or the.. pdf itself
77
and it will go in and actually read it summarize it
78
and provide me with insights now generative ai has to deal with ais
79
that produce new content so basically what chat chpt is anyway it went through
80
and found this pretty interesting stat on generative ai and it showed
81
that it had really high potential for automating data related tasks specifically around processing and collecting data.
82
I mean, this is all sort of meta, right?
83
I'm using ChatGPT to analyze this PDF and provide data insights to me on data insights of generative AI.
84
So pretty crazy.
85
Another key source of information was this website right here from Stack Overflow,
86
where they actually surveyed a bunch of developers around 90 ,000 on what their sentiment was towards AI.
87
One of the key findings from this was
88
that 77 % of those surveyed had a favorable opinion towards using AI in their workflow.
89
That's four out of five.
90
That's pretty high considering how much negativity you were towards AI recently.
91
Now, the results of this report are pretty damn long.
92
And so once again, I can use ChatGBT to go in
93
and analyze it and actually asked it to summarize it better around data science professionals
94
and how they felt AI was impacting their job.
95
And ChatGPT was able to point out a pretty interesting insight.
96
Compared to developers, data analysts and scientists and engineers had some of the most positive sentiment towards this technology.
97
Now, the document itself has a lot of numbers around how these different job titles feel around AI.
98
So I asked it to analyze these numbers, provide a comparison.
99
But I ran into some issues where it started hallucinating
100
and making up a lot of the values that it saw in this document right here.
101
So I was really confused with this, especially since I had provided it with the source document.
102
I don't know why I was fabricating these numbers.
103
I couldn't figure that out.
104
But anyway, nonetheless, I was able to find the actual table that it was referring to.
105
And with another plugin, I was actually able to go in,
106
pull these numbers out, and then visualize it in order to see how it compared to other developers.
107
All right, we're back to the green screen.
108
So we discovered that data nerds have some of the most favorable opinions about using AI tools in their job.
109
And next slide.
110
We also, this also satisfies what we needed here in understanding what people's thoughts were towards this technology.
111
And overall, what we're seeing, four out of five prefer.
112
I mean, I'd say that that's a pretty good score.
113
And frankly, I think this is good.
114
But what about this side for the businesses?
115
What are their thoughts about it?
116
I mean, they're the ones
117
that are actually going to be driving this type of change within organizations and ensure people are adapting to this new technology.
118
The McKinsey study that I referenced at the beginning of my research
119
basically confirmed that these AI tools are going to increase our economic output.
120
So it's a win -win situation for companies to actually utilize this for their employees.
121
Yes, I do understand that there's different privacy concerns around what can be put into these type of tools,
122
but that's something that we need to start thinking about now.
123
So with the research we did with ChatGPT, we weren't able to find any data that related to how companies are implementing these AI tools.
124
But I have an idea.
125
So I've been collecting job postings since last year, and I have more details about it in this video right here.
126
Anyway, I've collected over a million jobs for data science job postings.
127
This should show indirectly how companies feel about implementing these AI tools, whether they're even asking new employees to have these skills.
128
Now, this data set includes things like job title, salary, and even job description.
129
So what we're going to do is we're going to use ChatGPT to perform some NLP
130
and go in and extract out any data related to AI being used in these jobs.
131
So let's get into it.
132
All right, it's been a few days and I've made a lot of progress using ChatGPT and specifically using the Notable plugin.
133
And not only is it providing visualizations through the front end, but you can also see the code behind how this all worked.
134
And that's pretty cool that you can double check it with this.
135
One quick note is that ChatGPT will be releasing the Code Interpreter plugin in the near future.
136
And this plugin will be as powerful or even more powerful than this Notable plugin.
137
So getting into the analysis, All of the data is located in a database that has a secure connection.
138
So I asked ChatGPT how do I go about giving these credentials so that way it can access this data.
139
And at first, it tried to give me code to perform this, but I re -prompted and told it to use the installed plugin.
140
And with that, it gave me a link that I could input in the credentials of the database.
141
So to make sure that it was connected to the database, I asked it how many entries it had in this table,
142
which it told me it was about a million, so I knew we were connected.
143
Next, I prompted ChatGPT to provide me some descriptive statistics about the data set.
144
And it not only provided information about what columns were in the data set, but it also showed some statistics around the salary information.
145
I'm not gonna really use that right now, but I thought it was interesting that I provided it nonetheless.
146
Next, I wanted to get into analyzing these job postings for keywords around AI.
147
So I prompted ChatGPT for a list of keywords related to this.
148
And although good, it's not really what I wanted, as these are more theoretical terms and not necessarily tools.
149
I've analyzed terms like AI and artificial intelligence before, and I didn't really think the insights from those keywords were really
150
that great instead i want to use tools
151
that relate to af for this we're going to be using those tools
152
that were included in
153
that stack overflow survey not only are we going to focus on search tools
154
but also on developer tools so i gave chat gpt this list of tools
155
and ask it to analyze whether these keywords were included in the job descriptions
156
this is where i ran into a limitation of this notable plugin
157
because this data set is over a million rows
158
and tried to extract those million rows of data and import it into a pandas data frame within the notebook.
159
I did find an option to upgrade my small ass computer, but it looked like it was behind a wait list.
160
So I reached out to Notable on Twitter and asked them if I could access these larger computers.
161
And they told me to wait.
162
So we're only limited around 100 ,000 jobs for this, and so we used a random sampling for this analysis.
163
And double checking all the results that I got at the end of this, it doesn't look like the results really change or fluctuate that much.
164
So I think we're fine with using this sampling.
165
So the first thing I jumped into was telling ChatGPT that each one of these rows was a job posting.
166
And I was curious to find out what percentage of these jobs contain one of those tools.
167
And less than 2 % of jobs is even requesting the skill of AI tools in the job description.
168
So we're not really off to a good start.
169
I thought next, let's actually look into what are the actual tools that are appearing in those job descriptions.
170
And I had to reprompt ChatGPT several times, getting it to sort highest to low, displaying the y -axis as a percentage,
171
and then formatting it to include one decimal place.
172
But eventually, we got this visualization, which shows that
173
Bing and u .com are some of the highest requested tools.
174
I am a little confused by these results, as they don't really correlate really well to that
175
Stack Overflow survey, but they are less than 1%, so maybe this does make sense.
176
So next, I was curious, with this low percentage,
177
are they even paying those with these type of skills a higher salary once again had to reprompt
178
it to correct column names and also format the y -axis as a currency
179
and we finally get this showing data scientists do get paid more
180
but data engineers machine learning engineers and data analysts don't
181
and such a low percentage of these jobs including these search terms
182
i'm not ready to call anything conclusive off of this visualization just think
183
that we maybe should explore this more in the future
184
now i did want to get into one last thing looking
185
at how these different job titles compared to each other for containing these AI tools.
186
And it looks like machine learning engineers are leading the way, followed by data analysts and data scientists.
187
So with these results, I think we've shown pretty conclusively
188
that companies aren't caring as much as people are about implementing AI tools in their jobs.
189
And I think this is a pretty big problem,
190
that there's such a big disparity between those that want to actually implement AI tools in their jobs,
191
and then the companies not really requesting it in these jobs.
192
Anyway, I digress.
193
So, if you got value out of this video and you like AI, smash that like button.
194
If you don't like AI, like those companies, hit that dislike button.
195
I'm curious to know.
196
Anyway, I'll see you in the next one.
FOR YOU
推荐视频
本课的词汇与口语要点
这节口语课以视频“How I use ChatGPT as a Data Analyst”为素材。 视频中反复出现的词有:Chatgpt, tool, plugin。 这段视频共有 196 个句子、2646 个单词可供跟读。 讲话部分时长为 13:39。 说话人语速较快,每分钟约 194 个词,会出现较多连读和弱读。 82% 的单词属于英语最常用的 3,000 词,其余的词建议在练习前先学一下。
视频中的重点词汇
视频中 15 个值得学习的单词,附发音和释义:
| 单词 | 发音 | 释义 |
|---|---|---|
| insight 名词 | /ˈɪnsaɪ̯t/ | 見地 /见地 |
| analyze 动词 | /ˈæn.əˌlaɪz/ | 分析 |
| connect 动词 | /kəˈnɛkt/ | 連接 /连接 |
| percentage 名词 | /pə(ɹ)ˈsɛntɪd͡ʒ/ | 百分率, 百分比 |
| skill 名词 | /skɪl/ | 技巧, 技能 |
| salary 名词 | /ˈsæləɹi/ | 薪金, 薪水 |
| scientist 名词 | /ˈsaɪəntəst/ | 科學家 /科学家 |
| implement 动词 | /ˈɪmpləmənt/ | 實施 /实施, 執行 /执行 |
| notable 形容词 | /ˈnəʊtəbl̩/ | 著名 |
| stack 名词 | /stæk/ | 堆 |
| compare 动词 | /kəmˈpɛɚ/ | 比, 比較 /比较 |
| curious 形容词 | /ˈkjʊɹ.i.əs/ | 好奇, 有好奇心 |
| collect 动词 | /ˈkɑlɪkt/ | 庋藏, 收藏 |
| database 名词 | /ˈdeɪtəˌbeɪs/ | 數據庫 /数据库 |
| audio 形容词 | /ˈɔ.di.oʊ/ | 音頻 /音频, 伴音 |
视频中出现的短语动词
| 单词 | 发音 | 释义 |
|---|---|---|
| find out 动词 | 找出, 查明 | |
| go through 动词 | 通過 /通过 | |
| check out 动词 | 退房 | |
| make up 动词 | /ˌmeɪk ˈʌp/ | 組成 /组成 |
| point out 动词 | 指, 指出 | |
| put together 动词 | 拼合, 組合 /组合 | |
| stay up 动词 | 熬夜 | |
| take over 动词 | 接管, 接手 |
值得反复跟读的句子
视频中简短而完整的句子,可以直接用在日常对话里:
- With this calculation, let's actually time it.
- Let's get back to the video.
- I don't know why I was fabricating these numbers.
- I couldn't figure that out.
- All right, we're back to the green screen.
视频中的语法
说话人最常用的结构,并附上视频中的原话:
| 结构 | 视频中的用法 |
|---|---|
| 现在完成进行时 have/has been + -ing — 以前开始、现在仍在继续的动作 | I've been using · it's been saving · I've been collecting |
| 现在完成时 have/has + 过去分词 — 过去发生但与现在仍有关联的事 | we've generated · we've shown · I've also tried |
| 被动语态 be + 过去分词 — 强调发生了什么,而不是谁做的 | was only trained · can be put · being used |
需要注意的发音
说话人用了 57 次缩略和弱读形式,例如 we're, I've, I'm。请按听到的简短形式来说。
- “th” 音: nonetheless /ˌnʌnðəˈlɛs/, theoretical /ˌθi.əˈɹɛt.ɪ.kəl/
- “sh” 和 “zh” 音: artificial /ˌɑː.tɪˈfɪʃ.əl/, limitation /lɪmɪˈteɪʃən/, publication /ˌpʌblɪˈkeɪʃ(ə)n/, smash /smæʃ/, accomplish /əˈkɑm.plɪʃ/
- 长单词——注意重音位置: developer /dɪˈvɛləpɚ/, artificial /ˌɑː.tɪˈfɪʃ.əl/, capability /ˌkeɪ.pəˈbɪl.ɪ.ti/, limitation /lɪmɪˈteɪʃən/, favourable /ˈfeɪv(ə)ɹəbəl/
中文母语者容易读错的音:
- /v/ — 不要读成 /w/,上齿轻触下唇: developer /dɪˈvɛləpɚ/, solve /sɒlv/, favourable /ˈfeɪv(ə)ɹəbəl/, privacy /ˈpɹaɪ.və.si/, dive /daɪv/
- 词尾辅音 — 要读清楚,后面不要加元音: insight /ˈɪnsaɪ̯t/, analyze /ˈæn.əˌlaɪz/, analyst /ˈænəlɪst/, connect /kəˈnɛkt/, percentage /pə(ɹ)ˈsɛntɪd͡ʒ/
- /r/ 和 /l/ 的区别: salary /ˈsæləɹi/, favourable /ˈfeɪv(ə)ɹəbəl/, necessarily /ˌnɛs.əˈsɛɹ.ə.li/, explore /ɪkˈsploɹ/, rely /ɹɪˈlaɪ/
如何用这段视频练习
- 先完整听一遍视频,不要开口,记下不认识的单词。
- 先用 0.75 倍速逐句跟读,熟练之后再回到正常速度。
- 录下自己的声音并与原声对比,特别注意 insight, analyze, connect 这类单词。
什么是跟读法?
跟读法 (Shadowing) 是一种有科学依据的语言学习技巧,最初开发用于专业口译员的培训,并由多语言者Alexander Arguelles博士普及。这个方法简单而强大:您在听英语母语原声的同时立即大声重复——就像是一个延迟1-2秒紧跟说话者的影子。与被动听力或语法练习不同,跟读法强迫您的大脑和口腔肌肉同时处理并模仿真实的讲话模式。研究表明它能显着提高发音准确性,语调,节奏,连读,听力理解和口语流利度——使其成为雅思口语备考和真实英语交流最有效的方法之一。












