课程介绍
只会Excel，不知pandas是何物？那你可就out了！
现代办公室里几乎任何一项工作都会用到Excel，每打开一个job description，我们都会看到一句“要求精通Excel”。毋庸置疑，Microsoft Excel是世界上最流行、最好用的电子表格软件。它之所以如此受欢迎，主要是因为直观的操作界面，而且对于大多数常用的操作，都不用编程。数据会以表格、行和列的形式直接呈现在你的面前，通过简单的鼠标滑动你就能看到数据的全貌。制作一个清晰美观的图表也只需要选中目标表格、点击几个选项就能搞定。
不过，Excel的缺陷也是很明显的。相信常用Excel的人都体验过——Excel对计算机的性能要求比较高，对操作系统也比较挑剔；当文件过大的时候，Excel会变得很卡，甚至直接给你“玩儿崩溃”。总之，Excel在处理复杂的任务时效果还是不太理想。
了解数据分析的同学一定听说过Python中最常用的数据分析包——pandas。它是基于用来进行高效数据计算的numpy工具包建立起来的。相比于Excel，pandas可以实现的操作只多不少。
Pandas非常适合用来进行数据处理、数据清理、数据分析和数据探索。而且pandas可以让这些任务轻易地实现自动化，并且可以重复应用于不同的数据表。还有非常重要的一点，不同于Excel，pandas是完全免费的开源软件，而且还不受操作系统的限制——在Windows和MacOS上都能跑的溜溜的。
想象一下，用Excel加载一个大型数据表格就需要2分钟，一个Vlookup或者求和公式的操作又要用去5分钟，当表格发生变化时，可能还要重新进行计算，而一个简单的Python+pandas脚本就可能把你一个小时的工作量缩短到20秒之内完成。这……你有没有觉得不会pandas都不好意思跟人打招呼了？
现在的就业形势是：无论你是不是应聘数据相关的岗位，掌握pandas无疑都可以增加你的职场竞争力。即使已经拿到了offer、在岗位上工作，学习pandas提高工作效率，迎来同事崇拜的目光、赢得老板的赏识，升职加薪嘛，自然也会提速！
想学吗？心动吗？不知道在哪里能够又快又好又轻松地学会pandas？小编这就为大家奉上一个大礼包——由蔓藤教育出品的免费课程《Pandas versus Excel》。
每节课，“魔法老师”Tim会在简短的十几分钟里，用浅显易懂的方式教授大家常用的Excel操作以及对应到pandas里应该如何实现这些操作。通过这样的方式，同学们就可以利用自己的碎片时间，轻松掌握pandas、巩固Excel技能啦！
目录
{
"id": "89",
"isDefault": "1",
"learnMode": "freeMode",
"isMember": "",
"status": "published",
"currentTaskId": "",
"isHideUnpublish": "0"
}
{
"i18nChapterName": "章",
"i18nUnitName": "节",
"i18nLessonName": "课时",
"i18nTaskName":"任务"
}
[{"itemType":"task","number":"1","published_number":"1","title":"\u521b\u5efa\u6587\u4ef6","result":"","resultStatus":"","lock":false,"status":"published","taskId":"397","isOptional":"0","type":"video","isTaskFree":"1","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"12:24","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0,"isSingleTaskLesson":true},{"itemType":"task","number":"2","published_number":"2","title":"\u8bfb\u53d6\u6587\u4ef6","result":"","resultStatus":"","lock":false,"status":"published","taskId":"402","isOptional":"0","type":"video","isTaskFree":"1","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"17:27","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0,"isSingleTaskLesson":true},{"itemType":"task","number":"3","published_number":"3","title":"\u884c\uff0c\u5217\uff0c\u5355\u5143\u683c","result":"","resultStatus":"","lock":false,"status":"published","taskId":"403","isOptional":"0","type":"video","isTaskFree":"1","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"17:01","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0,"isSingleTaskLesson":true},{"itemType":"task","number":"4","published_number":"4","title":"\u6570\u636e\u533a\u57df\u7684\u8bfb\u53d6\uff0c\u586b\u5145\u6574\u6570\u3001\u6587\u5b57","result":"","resultStatus":"","lock":false,"status":"published","taskId":"406","isOptional":"0","type":"video","isTaskFree":"1","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"16:03","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0,"isSingleTaskLesson":true},{"itemType":"task","number":"5","published_number":"5","title":"\u586b\u5145\u65e5\u671f\u5e8f\u5217","result":"","resultStatus":"","lock":false,"status":"published","taskId":"407","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"10:48","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0,"isSingleTaskLesson":true},{"itemType":"task","number":"6","published_number":"6","title":"\u51fd\u6570\u586b\u5145","result":"","resultStatus":"","lock":false,"status":"published","taskId":"409","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"11:19","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0,"isSingleTaskLesson":true},{"itemType":"task","number":"7","published_number":"7","title":"\u6392\u5e8f\uff0c\u591a\u91cd\u6392\u5e8f","result":"","resultStatus":"","lock":false,"status":"published","taskId":"414","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"11:58","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0,"isSingleTaskLesson":true},{"itemType":"task","number":"8","published_number":"8","title":"\u6570\u636e\u7b5b\u9009\u3001\u8fc7\u6ee4","result":"","resultStatus":"","lock":false,"status":"published","taskId":"416","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"10:46","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0,"isSingleTaskLesson":true},{"itemType":"task","number":"9","published_number":"9","title":"\u67f1\u72b6\u56fe","result":"","resultStatus":"","lock":false,"status":"published","taskId":"417","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"18:00","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0,"isSingleTaskLesson":true},{"itemType":"task","number":"10","published_number":"10","title":"\u7ed8\u5236\u5206\u7ec4\u67f1\u56fe\uff0c\u6df1\u5ea6\u4f18\u5316\u56fe\u8868","result":"","resultStatus":"","lock":false,"status":"published","taskId":"418","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"13:14","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0,"isSingleTaskLesson":true},{"itemType":"task","number":"11","published_number":"11","title":"\u53e0\u52a0\u67f1\u72b6\u56fe\uff0c\u6c34\u5e73\u67f1\u72b6\u56fe","result":"","resultStatus":"","lock":false,"status":"published","taskId":"419","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"07:57","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0,"isSingleTaskLesson":true},{"itemType":"task","number":"12","published_number":"12","title":"\u7ed8\u5236\u997c\u56fe","result":"","resultStatus":"","lock":false,"status":"published","taskId":"421","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"11:30","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0,"isSingleTaskLesson":true},{"itemType":"task","number":"13","published_number":"13","title":"\u7ed8\u5236\u6298\u7ebf\u8d8b\u52bf\u56fe\u3001\u53e0\u52a0\u533a\u57df\u56fe","result":"","resultStatus":"","lock":false,"status":"published","taskId":"424","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"10:25","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0,"isSingleTaskLesson":true},{"itemType":"task","number":"14","published_number":"14","title":"\u6563\u70b9\u56fe\uff0c\u76f4\u65b9\u56fe\uff0c\u5bc6\u5ea6\u56fe","result":"","resultStatus":"","lock":false,"status":"published","taskId":"425","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"09:20","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0,"isSingleTaskLesson":true},{"itemType":"task","number":"15","published_number":"15","title":"\u5bc6\u5ea6\u56fe\uff0c\u6570\u636e\u76f8\u5173\u6027","result":"","resultStatus":"","lock":false,"status":"published","taskId":"426","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"09:45","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0,"isSingleTaskLesson":true},{"itemType":"task","number":"16","published_number":"16","title":"\u591a\u8868\u8054\u5408\uff08Join\uff09","result":"","resultStatus":"","lock":false,"status":"published","taskId":"428","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"17:30","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0,"isSingleTaskLesson":true},{"itemType":"task","number":"17","published_number":"17","title":"\u6570\u636e\u6821\u9a8c\uff0c\u8f74\u7684\u6982\u5ff5","result":"","resultStatus":"","lock":false,"status":"published","taskId":"430","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"10:10","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0,"isSingleTaskLesson":true},{"itemType":"task","number":"18","published_number":"18","title":"\u628a\u4e00\u5217\u6570\u636e\u5206\u5272\u6210\u4e24\u5217","result":"","resultStatus":"","lock":false,"status":"published","taskId":"432","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"10:00","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0,"isSingleTaskLesson":true},{"itemType":"task","number":"19","published_number":"19","title":"\u6c42\u548c\uff0c\u6c42\u5e73\u5747\uff0c\u7edf\u8ba1\u5bfc\u5f15","result":"","resultStatus":"","lock":false,"status":"published","taskId":"435","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"14:00","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0,"isSingleTaskLesson":true},{"itemType":"task","number":"20","published_number":"20","title":"\u5b9a\u4f4d\u3001\u6d88\u9664\u91cd\u590d\u6570\u636e","result":"","resultStatus":"","lock":false,"status":"published","taskId":"436","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"10:15","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0,"isSingleTaskLesson":true},{"itemType":"task","number":"21","published_number":"21","title":"\u65cb\u8f6c\u6570\u636e\u8868\uff08\u884c\/\u5217\u8f6c\u6362\uff09","result":"","resultStatus":"","lock":false,"status":"published","taskId":"439","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"04:15","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0,"isSingleTaskLesson":true},{"itemType":"task","number":"22","published_number":"22","title":"\u8bfb\u53d6CSV\u3001TSV\u3001TXT\u6587\u4ef6\u4e2d\u7684\u6570\u636e","result":"","resultStatus":"","lock":false,"status":"published","taskId":"442","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"10:15","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0,"isSingleTaskLesson":true},{"itemType":"task","number":"23","published_number":"23","title":"\u900f\u89c6\u8868\uff0c\u5206\u7ec4\uff0c\u805a\u5408\uff08group by\uff09","result":"","resultStatus":"","lock":false,"status":"published","taskId":"443","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"12:40","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0,"isSingleTaskLesson":true},{"itemType":"task","number":"24","published_number":"24","title":"\u7ebf\u6027\u56de\u5f52\uff0c\u6570\u636e\u9884\u6d4b","result":"","resultStatus":"","lock":false,"status":"published","taskId":"447","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"09:45","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0,"isSingleTaskLesson":true},{"itemType":"task","number":"25","published_number":"25","title":"\u6761\u4ef6\u683c\u5f0f\u5316\uff08\u4e0a\uff09","result":"","resultStatus":"","lock":false,"status":"published","taskId":"449","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"12:10","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0,"isSingleTaskLesson":true},{"itemType":"task","number":"26","published_number":"26","title":"\u6761\u4ef6\u683c\u5f0f\u5316\uff08\u4e0b\uff09","result":"","resultStatus":"","lock":false,"status":"published","taskId":"450","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"05:00","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0,"isSingleTaskLesson":true},{"itemType":"task","number":"27","published_number":"27","title":"\u884c\u64cd\u4f5c\u96c6\u9526","result":"","resultStatus":"","lock":false,"status":"published","taskId":"453","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"20:35","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0,"isSingleTaskLesson":true},{"itemType":"task","number":"28","published_number":"28","title":"\u5217\u64cd\u4f5c\u96c6\u9526","result":"","resultStatus":"","lock":false,"status":"published","taskId":"454","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"14:20","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0,"isSingleTaskLesson":true},{"itemType":"task","number":"29","published_number":"29","title":"\u8bfb\u53d6\u6570\u636e\u5e93","result":"","resultStatus":"","lock":false,"status":"published","taskId":"455","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"13:25","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0,"isSingleTaskLesson":true},{"itemType":"task","number":"30","published_number":"30","title":"\u7f16\u5199\u590d\u6742\u65b9\u7a0b","result":"","resultStatus":"","lock":false,"status":"published","taskId":"456","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"09:10","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0,"isSingleTaskLesson":true}]
{
"text": {
"icon": "es-icon es-icon-graphicclass",
"name": "图文"
}
,
"video": {
"icon": "es-icon es-icon-videoclass",
"name": "视频"
}
,
"audio": {
"icon": "es-icon es-icon-audioclass",
"name": "音频"
}
,
"live": {
"icon": "es-icon es-icon-videocam",
"name": "直播"
}
,
"discuss": {
"icon": "es-icon es-icon-comment",
"name": "讨论"
}
,
"flash": {
"icon": "es-icon es-icon-flashclass",
"name": "Flash"
}
,
"doc": {
"icon": "es-icon es-icon-description",
"name": "文档"
}
,
"ppt": {
"icon": "es-icon es-icon-pptclass",
"name": "PPT"
}
,
"testpaper": {
"icon": "es-icon es-icon-kaoshi",
"name": "考试"
}
,
"homework": {
"icon": "es-icon es-icon-zuoye",
"name": "作业"
}
,
"exercise": {
"icon": "es-icon es-icon-mylibrarybooks",
"name": "练习"
}
,
"download": {
"icon": "es-icon es-icon-filedownload",
"name": "下载资料"
}
}
1713618431
授课教师
Tim老师
课程特色
视频(30)
下载资料(25)
