シャドーイング練習: How I use ChatGPT as a Data Analyst - 動画で英語スピーキングを学ぶ

練習モードを選ぶ

各モードは全画面の練習ルームで開きます。

196 文

文が短すぎたり長すぎる場合は、Editをタップして調整してください。

Data nerds!

I've been using ChatGPT to analyze data for my job.

And it's been saving me a lot of time.

Let me show you what I mean.

So here we have a spreadsheet with some data we want to analyze.

First, I asked it to connect to the data by providing it with a link to the spreadsheet.

It gives me the first few reads of the data so I know it's connected.

So next, I ask it, what's this dataset even about?

And it looks like it's a bunch of job postings specifically for the role of data analyst.

It even provides some basic stats about the columns in the spreadsheet.

Let's do some quick EDA to see what are the 10 most common jobs.

And it provides me this bar graph with data analyst as the most common job title, followed by senior data analysts.

Let's wrap this analysis up and check out what the median salary is for these 10 most common jobs.

With this calculation, let's actually time it.

And in just over a minute, we're able to generate both these visualizations.

You can see that data scientists have some of the highest, while data analysts have some of the lowest.

I don't like this.

So I did this entire analysis before filming this without ChatGPT, and it took me almost an hour.

And here, in less than a few minutes, we've generated all of these different visualizations and insights without even coding one bit.

Now that we've shown ChatGPT's capabilities, let's move on to an even bigger problem that we're going to solve.

All right, so I stayed up a little bit too late last night.

How's my audio?

My audio good?

And I put together this PowerPoint of how we're going to solve this problem

and there's a lot of hype around AI lately

and whether it's going to actually automate and take away jobs and is it going to take over the world

probably but more importantly we want to focus on how is AI impacting data jobs

and we'll look at two main aspects first from the people's aspect from the person

that has the job how satisfied are they with AI impacting

their jobs the next one is businesses is there going to be an actual impact such as financial

or they're going to be actually be looking for those with skills of this AI

and how we're going to accomplish this all well here's the game plan

I have a two -step approach the first is using chat gpt for data research

we're going to be using different plugins

and internet searching methods in order to find research papers data whatever

it may be in order to find insights into those two main areas

that we're trying to look at from there we're going to move into data analysis

and we're going to once again use chat gpt to actually analyze this data

that we found in order to find insights and maybe prove one way

or another whether how bad ai is impacting data science jobs

but before we just dive into this analysis we need to understand the capabilities of this tool chat gbt

so um brb so what the heck is chat gpt well i asked it

and come to find out it's an artificial intelligence that's running on one of the models from OpenAI.

Specifically, this one right here, I'm using model GPT -4, which is their newest and greatest one.

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.

I've also tried all these other options and done a cold comparison video,

and I've found that ChatGPT is the best at performing data analysis at the moment.

But there is a catch with ChatGPT, and that comes to pricing.

So you can use the free version of ChatGPT and go in and prompt it and get different insights from it,

but you're really going to be limited in what you get.

Now, if you go with the pro version, not only do you have access to an improved model of GPT -4,

but also you have access to plugins.

And plugins are really the money.

Plugins allow these chatbots to connect to different applications.

So recently I've been using it with Wolfram in order to connect

and do analysis on the backend and then feed it back into ChatGPT so I can get my numbers crunched.

All right, enough with this green screen break.

Let's get back to the video.

All right, I made some progress on using ChatGPT to go

and search the internet to find things around AI impacting data science jobs.

And first up is one of the limitations that I found with ChatGPT,

and that's that the model itself was only trained on data up to September of 2021.

This has been a really big problem

because you can't actually ask the model directly about things that have happened right now because it won't know.

That's where plugins come in.

The first main one that I've been using to search the internet is their Bing plugin

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.

Now, ChatGPT isn't really that great.

I also tested out

Bing and also the Google competitor, Bard, and they're not really search engines, right?

So I still rely on Google itself to go in and search, but I was able to find some recent articles on this,

specifically this one from McKinsey talking about the economic impact of generative AI.

Now this bad boy is almost a hundred pages long.

And if you think I'm going to go through and read it, you're probably wrong.

So what's good about ChatGPT is they have plugins in order to read these type of PDFs.

I just give it the link or the.. pdf itself

and it will go in and actually read it summarize it

and provide me with insights now generative ai has to deal with ais

that produce new content so basically what chat chpt is anyway it went through

and found this pretty interesting stat on generative ai and it showed

that it had really high potential for automating data related tasks specifically around processing and collecting data.

I mean, this is all sort of meta, right?

I'm using ChatGPT to analyze this PDF and provide data insights to me on data insights of generative AI.

So pretty crazy.

Another key source of information was this website right here from Stack Overflow,

where they actually surveyed a bunch of developers around 90 ,000 on what their sentiment was towards AI.

One of the key findings from this was

that 77 % of those surveyed had a favorable opinion towards using AI in their workflow.

That's four out of five.

That's pretty high considering how much negativity you were towards AI recently.

Now, the results of this report are pretty damn long.

And so once again, I can use ChatGBT to go in

and analyze it and actually asked it to summarize it better around data science professionals

and how they felt AI was impacting their job.

And ChatGPT was able to point out a pretty interesting insight.

Compared to developers, data analysts and scientists and engineers had some of the most positive sentiment towards this technology.

Now, the document itself has a lot of numbers around how these different job titles feel around AI.

So I asked it to analyze these numbers, provide a comparison.

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.

アプリをダウンロード

流暢に話すために必要なすべて

AI発音採点文ごとに採点

IPA練習すべての音をマスター

単語学習自分の単語帳を作る

単語ゲーム遊びながら覚える

QRをスキャン

Download on theApp Store Get it onGoogle Play

FOR YOU

このレッスンの語彙とスピーキングのポイント

このスピーキングレッスンは、動画「How I use ChatGPT as a Data Analyst」を教材にしています。繰り返し出てくる語は次のとおりです：Chatgpt, tool, plugin。この動画には、シャドーイング用の文が196文、単語が2646語あります。音声の長さは13:39です。話す速さは速く、1分あたり約194語です。音のつながりや弱く発音される音が多くなります。単語の82%は英語の頻出3,000語に含まれます。残りは練習の前に確認しておきましょう。

この動画の重要語彙

動画に出てくる覚えておきたい単語15語を、発音と意味つきで紹介します。

単語	発音	意味
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ʊ/	オーディオ
format 名詞	/ˈfɔːɹ.mæt/	書式, フォーマット

動画に出てくる句動詞

単語	意味
find out 動詞	見出す, 調べる
check out 動詞	試験する, 検査する
point out 動詞	指す, 指し示す
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

注意したい発音

話し手はwe're, I've, I'mなど、短縮形や弱形を57回使っています。聞こえたとおりの短い形で発音しましょう。

「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/

日本語話者が苦手な音：

/r/ と /l/ の区別 — /l/ は舌先を歯茎につけ、/r/ はどこにもつけない: salary /ˈsæləɹi/, favourable /ˈfeɪv(ə)ɹəbəl/, necessarily /ˌnɛs.əˈsɛɹ.ə.li/, explore /ɪkˈsploɹ/, rely /ɹɪˈlaɪ/
/v/ — /b/ にならないように、上の歯を下唇に当てる: developer /dɪˈvɛləpɚ/, solve /sɒlv/, favourable /ˈfeɪv(ə)ɹəbəl/, privacy /ˈpɹaɪ.və.si/, dive /daɪv/
/f/ — 「フ」ではなく、上の歯と下唇で出す: confused /kənˈfjuːzd/, format /ˈfɔːɹ.mæt/, artificial /ˌɑː.tɪˈfɪʃ.əl/, satisfy /ˈsætɪsfaɪ/, favourable /ˈfeɪv(ə)ɹəbəl/

この動画での練習方法

まず声を出さずに動画を最後まで聞き、知らない単語をメモします。
まず0.75倍速で一文ずつシャドーイングし、慣れてきたら通常の速度に戻します。
自分の声を録音して元の音声と比べます。analyze, connect, percentageなどの単語に特に注意しましょう。

シャドーイングとは？英語上達に効果的な理由

シャドーイング（Shadowing）は、もともとプロの通訳者養成プログラムで開発された言語学習法で、多言語習得者として知られるDr. Alexander Arguelles によって広く普及されました。方法はシンプルですが非常に効果的：ネイティブスピーカーの英語を聞きながら、1〜2秒の遅延で声に出してすぐに繰り返す——まるで「影（shadow）」のように話者を追いかけます。文法ドリルや受動的なリスニングと異なり、シャドーイングは脳と口の筋肉が同時にリアルタイムで英語を処理・再現することを強制します。研究により、発音精度、抑揚、リズム、連音、リスニング力、そして会話の流暢さが大幅に向上することが確認されています。IELTSスピーキング対策や自然な英語コミュニケーションを目指す方に特におすすめです。

シャドーイングのやり方: ステップ別の完全ガイドを読む →

シャドーイング練習: How I use ChatGPT as a Data Analyst - 動画で英語スピーキングを学ぶ

練習モードを選ぶ

アプリをダウンロード

おすすめ動画

ChatGPT Tutorial | Chat GPT Explained | What is Chat GPT ? | Edureka

day in the life working as a business analyst | my business analysis workflow

How AI Is Changing the Working World

She Fell in Love With ChatGPT. Like, Actual Love. With Sex.

AI Made the Most Passive Side Hustle Even Easier

Try Not to Cringe: AI Psychosis

How Anthropic uses Claude in Product Management

Introducing GPT-6 Astra for developers

Can you learn English with AI?

Fastest way to become an AI Engineer in 2026

THIS ChatGPT tool can be your English coach

I Looked Into How Devs Are Actually Using AI