用 Python 做商管程式設計（二）(Programming for Business Computing in Python (2))

Build in-demand skills with a full year of Coursera Plus, now $239. Save now.

用 Python 做商管程式設計（二）(Programming for Business Computing in Python (2))

Instructor: 盧信銘

12,357 already enrolled

Included with Learn more

4 modules

Gain insight into a topic and learn the fundamentals.

261 reviews

Intermediate level

Some related experience required

9 hours to complete

4 modules

Gain insight into a topic and learn the fundamentals.

261 reviews

Intermediate level

Some related experience required

9 hours to complete

What you'll learn

掌握 Python 核心觀念：函數（參數、傳回值、變數視野、遞迴）與字串操作，包含中文處理與 f-string 格式化輸出。
運用 Tuple、Dictionary、Set 與 datetime，並學會檔案讀寫與例外處理，讓程式更穩定。
用 Python 分析股票報酬等財金資料：CSV 資料清理與合併、CAPM 與市場模型、迴歸分析與視覺化。

Skills you'll gain

Tools you'll learn

Python Programming

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

4 assignments

Taught in Chinese (Traditional)

Flexible schedule

Learn at your own pace

See how employees at top companies are mastering in-demand skills

Learn more about Coursera for Business

logos of Petrobras, TATA, Danone, Capgemini, P&G and L'Oreal

There are 4 modules in this course

接續用 Python 做商管程式設計（一）的內容，我們將在這個課程中繼續探討Python語言中的許多核心觀念，包含函數、字串、常用的資料結構、檔案讀寫、例外處理等。最後以一個財金資料分析的例子總結。完成本次課程之後，你將會對Python有更深入的了解，並且可以利用Python實際處理一些簡單的資料分析問題。

函數是發展有結構的，有用的，易維護的程式必備的工具。適當的使用函數可以讓你自己以及與你一起工作的伙伴們可以有效率的建構出有用的程式碼。讓我們一起來學習這個重要的主題吧!

What's included

7 videos1 reading1 assignment

7 videosTotal 123 minutes

1-1 Functions: 基本概念17 minutes
1-2 函數的 Parameters 與 Arguments13 minutes
1-3 定義與呼叫函數16 minutes
1-4 變數的視野 (Scope)21 minutes
1-5 函數的傳回值15 minutes
1-6 函數傳入值 (Arguments)、傳回值、與指定傳入法 (Call by Assignment)20 minutes
1-7 遞迴 (Recursion) 與除錯 (Debugging)21 minutes

1 readingTotal 1 minute

NTU MOOC 課程問題詢問與回報機制1 minute

1 assignmentTotal 25 minutes

函數練習25 minutes

字串是常用的資料型別，也是很多情境中程式操作的對象。我們將介紹字串的基本操作，輔以台灣身分證字號驗證的例子，並且討論中文處理的一些議題。最後介紹格式化字串輸出的一些方法。

What's included

9 videos1 assignment

9 videosTotal 117 minutes

2-1 字串資料型別14 minutes
2-2 字串操作14 minutes
2-3 台灣身分證字號驗證問題9 minutes
2-4 驗證16 minutes
2-5 我要 Python 講中文15 minutes
2-6 字元與其內碼8 minutes
2-7 字串操作9 minutes
2-8 格式化字串輸出13 minutes
2-9 再談格式化字串輸出：F-STRING18 minutes

1 assignmentTotal 20 minutes

練習題20 minutes

本週將介紹三個議題。首先將介紹幾個常用的資料結構，如Tuples, Dictionary, Set, Datetime等。這些資料結構可以幫助你更有效率的完成任務。接下來將介紹檔案讀寫的觀念與做法。最後將說明例外處理。例外處理可以讓我們自己定義程式遇到錯誤時的行為，這常常可以讓你的程式更成熟，更人性，更流暢。

What's included

12 videos1 assignment

12 videosTotal 140 minutes

3-1 簡介資料結構、檔案讀寫、與例外處理2 minutes
3-2 Tuples7 minutes
3-3 Zip, Map, 與 Lambda14 minutes
3-4 Dictionary13 minutes
3-5 字典的 Key 與 Value；反向對應11 minutes
3-6 Sets12 minutes
3-7-1 Aliasing and Cloning20 minutes
3-7-2 From Shallow Copy to Deep Copy13 minutes
3-8 Datetime10 minutes
3-9 Reading and Writing Files- Concepts and Path String13 minutes
3-10 Reading and Writing Files- Mode and Encoding10 minutes
3-11 Errors and Exceptions14 minutes

1 assignmentTotal 30 minutes

練習題30 minutes

本週將以分析股票報酬為例，介紹資料分析的流程。我們將先簡單的介紹資產定價模型，然後以這個模型為基礎，分析股票日報酬資料。最後並介紹基本資料視覺化的工具。

What's included

9 videos1 assignment

9 videosTotal 92 minutes

4-1 股票市場簡介7 minutes
4-2 資產定價模型 (CAPM) 與市場模型 (Market Model)9 minutes
4-3 資料分析步驟與資料取得7 minutes
4-4 資料前處理: 檔案讀取9 minutes
4-5 CSV檔案格式處理與資料清理12 minutes
4-6 CSV檔案排序6 minutes
4-7 市場報酬資料處理與資料合併13 minutes
4-8 迴歸分析11 minutes
4-9 迴歸結果分析與視覺化18 minutes

1 assignmentTotal 20 minutes

練習題20 minutes

Instructor

Instructor ratings

(45 ratings)

盧信銘

National Taiwan University

1 Course12,357 learners

Offered by

National Taiwan University

Explore more from Software Development

Nanjing University
Data Processing Using Python
Course
EDUCBA
Python Case Study - Customer Brokerage Management System
Course
Red Hat
Python Programming with Red Hat
Course
Corporate Finance Institute
Getting Started with Python
Course

Why people choose Coursera for their career

Felipe M.

Learner since 2018

"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."

Jennifer J.

Learner since 2020

"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."

Larry W.

Learner since 2021

"When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go."

Chaitanya A.

"Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits."

Learner reviews

5 stars
70.88%
4 stars
21.45%
3 stars
4.21%
2 stars
2.29%
1 star
1.14%

Showing 3 of 261

5.0

Reviewed on Oct 9, 2018

非常棒！👍 UTF-8 Big-5那邊的encoding設定講得很清楚。最後的檔案讀取、寫入、去頭尾、格式選擇，是整個課程高潮，講得很，覺得以後拿出來實用的機會高！此外，好想聽 pdb debug哦，老師再開一門吧！

5.0

Reviewed on Aug 13, 2020

Learn a lot from the course. Thank NTU for providing the valuable resources.

5.0

Reviewed on Apr 10, 2020

老師解釋得很清楚, 每一步都很小步, 進度和難度掌握得很好, 每周都感覺很有挑戰但同時又不會卡到想放棄. 沒想到不知不覺地就上完了!

View more reviews

What brings you to Coursera today?

Start my career

Change my career

Grow in my current role

Explore topics outside of work

Give yourself skills that last, now $239
Save now
Gift your team new skills
Save 40% now

Frequently asked questions

To access course materials, assignments, and earn a Certificate, you'll need to purchase the Certificate experience when you enroll in a course. Eligible learners may also have the option to start with a Free Trial. Some courses may also offer a Full Course, No Certificate option. This lets you access course materials, submit required assessments, and receive a final grade, but you won't be able to earn or purchase a Certificate.

When you enroll in the course, you get access to all of the courses in the Specialization, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile.

Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.