Этот материал находится в платной подписке. Оформи премиум подписку и смотри или слушай Move from Excel to Python with Pandas, а также все другие курсы, прямо сейчас!
Купить сейчас
  • Урок 1. 00:01:46
    Welcome!
  • Урок 2. 00:01:29
    Challenges of Excel
  • Урок 3. 00:01:47
    Where do Excel errors come from?
  • Урок 4. 00:01:26
    Why Python?
  • Урок 5. 00:01:03
    Course topics
  • Урок 6. 00:00:10
    Get the source
  • Урок 7. 00:00:35
    Meeting your instructor
  • Урок 8. 00:01:01
    Python concepts you'll need
  • Урок 9. 00:00:49
    Working on Windows
  • Урок 10. 00:00:12
    Downloading miniconda
  • Урок 11. 00:00:38
    Installing miniconda
  • Урок 12. 00:00:23
    Launching miniconda
  • Урок 13. 00:01:52
    Creating a conda environment
  • Урок 14. 00:00:50
    Conda quick reference
  • Урок 15. 00:00:51
    Getting organized
  • Урок 16. 00:01:01
    Recommended file structure
  • Урок 17. 00:00:21
    Launching Jupyter notebooks
  • Урок 18. 00:00:43
    Auto launch Conda env with Windows terminal
  • Урок 19. 00:01:05
    Create a project with cookiecutter
  • Урок 20. 00:00:59
    Launching Jupyter notebooks
  • Урок 21. 00:00:45
    Organizing within the notebook
  • Урок 22. 00:00:49
    Data compatible with Pandas
  • Урок 23. 00:00:40
    Where does excel fit in?
  • Урок 24. 00:00:49
    Intro to pandas
  • Урок 25. 00:01:13
    Pandas DataFrame vs Excel worksheets
  • Урок 26. 00:00:47
    Understanding initial data introduction
  • Урок 27. 00:04:13
    Demo: Understanding initial data
  • Урок 28. 00:00:31
    Concept: Understanding your dataframe
  • Урок 29. 00:03:14
    Working with column names
  • Урок 30. 00:02:43
    Diving into the data
  • Урок 31. 00:03:00
    Working with multiple columns
  • Урок 32. 00:01:12
    Concept: Working with columns
  • Урок 33. 00:07:47
    Working with column names
  • Урок 34. 00:00:48
    Concept: Selecting rows and columns
  • Урок 35. 00:02:15
    Advanced autocomplete and help
  • Урок 36. 00:00:32
    What is data wrangling?
  • Урок 37. 00:00:59
    Pandas data types
  • Урок 38. 00:01:45
    Walk through of data types in Excel
  • Урок 39. 00:03:23
    Pandas' dt, the date time accessor
  • Урок 40. 00:04:23
    String and math manipulations
  • Урок 41. 00:00:45
    Concept: Filtering data
  • Урок 42. 00:04:39
    Examples of boolean filtering in pandas
  • Урок 43. 00:03:54
    Filtering by dates
  • Урок 44. 00:01:40
    Concept: Filtering and cleaning text and dates
  • Урок 45. 00:01:00
    Aggregating merging grouping intro
  • Урок 46. 00:01:05
    Examples of aggregation in excel
  • Урок 47. 00:08:44
    Examples of aggregation in pandas
  • Урок 48. 00:00:37
    Concept: Pandas groupby
  • Урок 49. 00:01:34
    Concept: Pivot tables and crosstab
  • Урок 50. 00:04:43
    Pivot table and crosstab
  • Урок 51. 00:02:16
    Merging data in Excel
  • Урок 52. 00:05:36
    Merging data in Pandas
  • Урок 53. 00:00:31
    Concept: Appending data
  • Урок 54. 00:00:30
    Intro to I/O
  • Урок 55. 00:03:58
    Reading non-tabular Excel files
  • Урок 56. 00:04:53
    Reading Excel and converting data types
  • Урок 57. 00:00:41
    Reading Excel summary
  • Урок 58. 00:02:30
    Demo: Simple Excel saves
  • Урок 59. 00:02:07
    Demo: Multi-sheet Excel workbooks
  • Урок 60. 00:02:26
    Demo: Complex Excel saves
  • Урок 61. 00:00:26
    Excel writer summary
  • Урок 62. 00:00:46
    Excel fails at reading this large file
  • Урок 63. 00:01:57
    Pandas loves large files
  • Урок 64. 00:00:36
    Case study introduction
  • Урок 65. 00:00:44
    Environment setup
  • Урок 66. 00:00:29
    Excel file intro
  • Урок 67. 00:01:28
    Notebook setup for file reading
  • Урок 68. 00:04:00
    Commission rate calculations
  • Урок 69. 00:00:55
    Summary results lead to more questions
  • Урок 70. 00:01:51
    Combining customer sales reps
  • Урок 71. 00:02:47
    Cleaning up region
  • Урок 72. 00:02:01
    Merging sales reps
  • Урок 73. 00:04:33
    Cleaned, joined file
  • Урок 74. 00:00:36
    Excel file review
  • Урок 75. 00:00:32
    Process review
  • Урок 76. 00:00:50
    Excel invoice files
  • Урок 77. 00:01:38
    Excel customer invoice files
  • Урок 78. 00:03:07
    Product commission scenarios
  • Урок 79. 00:02:47
    Product commission variable amounts
  • Урок 80. 00:03:19
    Commission state adjustments
  • Урок 81. 00:02:12
    Final Excel report
  • Урок 82. 00:01:31
    Wrapping up
  • Урок 83. 00:01:15
    Excel challenges
  • Урок 84. 00:00:52
    Conda review
  • Урок 85. 00:01:29
    File structure for Jupyter
  • Урок 86. 00:01:06
    DataFrame summary
  • Урок 87. 00:01:26
    Data wrangling
  • Урок 88. 00:01:34
    Grouping and joining data
  • Урок 89. 00:00:40
    File I/O
  • Урок 90. 00:01:17
    Practical example
  • Урок 91. 00:01:03
    Thank you and next steps
  • Урок 92. 00:01:26
    Concept: The shape of a program
  • Урок 93. 00:00:51
    Concept: Variables
  • Урок 94. 00:01:47
    Concept: Truthiness
  • Урок 95. 00:01:25
    Concept: If else
  • Урок 96. 00:01:32
    Concept: Complex conditionals
  • Урок 97. 00:01:41
    Concept: for-in
  • Урок 98. 00:01:00
    Concept: Calling functions
  • Урок 99. 00:01:34
    Concept: Creating functions
  • Урок 100. 00:01:20
    Concept: File I/O
  • Урок 101. 00:02:00
    Concept: Imports and importing modules
  • Урок 102. 00:01:54
    Concept: Python package index
  • Урок 103. 00:02:26
    Concept: pip
  • Урок 104. 00:03:54
    Concept: Virtual environments
  • Урок 105. 00:02:54
    Concept: Slicing
  • Урок 106. 00:01:44
    Concept: Tuples
  • Урок 107. 00:01:44
    Concept: Named tuples
  • Урок 108. 00:02:01
    Concept: Classes
  • Урок 109. 00:01:45
    Concept: objects vs. classes
  • Урок 110. 00:01:50
    Concept: Inheritance
  • Урок 111. 00:00:54
    Concept: Polymorphism
  • Урок 112. 00:02:31
    Concept: Dictionaries
  • Урок 113. 00:02:39
    Concept: Error handling
  • Урок 114. 00:02:09
    Concept: lambdas
  • Урок 115. 00:02:58
    Concept: list comprehensions
  • Урок 116. 00:00:47
    Concept: Want more foundational Python?