PirateBay Download | udemy excel automation using python

udemy excel automation using python

Type:: Other
Files:: 206
Size:: 4.4 GB
Uploaded On:: Jan. 18, 2021, 4:29 a.m.
Added By:: tuts756
Seeders:: 2
Leechers:: 0
Info Hash:: 1B9BE2BD9B6E10F89A8FEB8565BB4DD18ED4471B

Description Excel spreadsheets are ubiquitous and no corporate job is possible without them. Like you, I have been working with them since I started my career. However, I rarely use excel now since I have automated most of my excel based tasks using python which has done wonders to my productivity and I want to help you do the same. I have created this course to help you automate your excel spreadsheets based tasks using python and improve your productivity manifold. ############################################################################################# Are you someone whose day job requires a lot of manual handling of buggy macros and working on voluminous excel files? Are you fed up with the tyranny of vlookups, Sumifs, pivot tables and excel dashboards and looking to upskill? Are you the type of person who would prefer the convenience of python over the unsightliness of VBA code? If the answer to any of the above questions is yes then you should consider this course. This course will start from the basics and will help you automate reasonably sophisticated excel based tasks. The course will also provide you with enough preparation to explore more advanced topics pertaining to automation/data analysis. The course covers following topics Creating python environment Importing excel into python Aggregating data from multiple files Splitting data into multiple files Interacting with your OS programmatically Automating popular excel functions such as vlookup, sumif, countif, iserror etc Automating pivot tables Automating dashboards ############################################################################################# Important note – Course prerequisites: Please note that this course requires basic python proficiency. At the minimum, you should be comfortable with: basic python data types and format basic python data structures such as list, dictionary, tuple etc. how to create python functions how to implement loops in python ############################################################################################# Who this course is for: Heavy users of excel curious about automating their work using python People who are tired of working with buggy macros and voluminous spreadsheets Requirements Python basics (data types, loops, functions etc.) Last Updated 12/2020

Get This Torrent

[TutsNode.com] - Excel Automation Using Python/3. Pandas Intro/4. ImportingExporting Data from Excel Spreadsheet.mp4 209.3 MB
TutsNode.com.txt 63 bytes
[TutsNode.com] - Excel Automation Using Python/3. Pandas Intro/7. Combining DataFrames (Concatenate, Merge & Join).srt 30.9 KB
[TutsNode.com] - Excel Automation Using Python/3. Pandas Intro/4. ImportingExporting Data from Excel Spreadsheet.srt 30.4 KB
[TutsNode.com] - Excel Automation Using Python/5. Implementing Excel Functions in Python/1. Vlookup - I.srt 25.6 KB
[TutsNode.com] - Excel Automation Using Python/6. Visualization/12. Visualization Assignment 1 Solution - II.srt 23.2 KB
[TutsNode.com] - Excel Automation Using Python/3. Pandas Intro/10. Numpy Assignment Solution.srt 22.7 KB
[TutsNode.com] - Excel Automation Using Python/6. Visualization/5. Hands on With Matplotlib OO Interface - I.srt 22.4 KB
[TutsNode.com] - Excel Automation Using Python/6. Visualization/14. Visualization Assignment 2 Solution.srt 21.9 KB
[TutsNode.com] - Excel Automation Using Python/3. Pandas Intro/3. Pandas Dataframe.srt 21.4 KB
[TutsNode.com] - Excel Automation Using Python/6. Visualization/9. Combining Pandas Visualization with OO Capabilities - II.srt 21.1 KB
[TutsNode.com] - Excel Automation Using Python/2. Numpy Intro/4. Numpy Operations.srt 20.9 KB
[TutsNode.com] - Excel Automation Using Python/3. Pandas Intro/12. Pandas Assignment Solution.srt 18.8 KB
[TutsNode.com] - Excel Automation Using Python/3. Pandas Intro/6. Handling NaN Values.srt 18.8 KB
[TutsNode.com] - Excel Automation Using Python/2. Numpy Intro/2.1 np_1d_array.py 655 bytes
[TutsNode.com] - Excel Automation Using Python/2. Numpy Intro/5. Indexing and Slicing.srt 17.6 KB
[TutsNode.com] - Excel Automation Using Python/6. Visualization/11. Visualization Assignment 1 Solution - I.srt 16.3 KB
[TutsNode.com] - Excel Automation Using Python/2. Numpy Intro/3.1 np_2d3d_array.py 788 bytes
[TutsNode.com] - Excel Automation Using Python/6. Visualization/8. Combining Pandas Visualization with OO Capabilities - I.srt 15.9 KB
[TutsNode.com] - Excel Automation Using Python/3. Pandas Intro/8. Data AggregationSummarization using Groupby.srt 15.9 KB
[TutsNode.com] - Excel Automation Using Python/2. Numpy Intro/4.1 np_operations.py 1.0 KB
[TutsNode.com] - Excel Automation Using Python/3. Pandas Intro/5. Handling PythonDataframe Data Types.srt 15.9 KB
[TutsNode.com] - Excel Automation Using Python/6. Visualization/7. Hands on With Matplotlib OO Interface - III.srt 14.9 KB
[TutsNode.com] - Excel Automation Using Python/2. Numpy Intro/5.1 np_indexing.py 1.0 KB
[TutsNode.com] - Excel Automation Using Python/4. OS Interaction Using Python/6. Assignment Solution - Organizing Files.srt 14.7 KB
[TutsNode.com] - Excel Automation Using Python/3. Pandas Intro/9.1 commute.xlsx 14.5 KB
[TutsNode.com] - Excel Automation Using Python/3. Pandas Intro/1. The Power of Pandas (Teaser Video).srt 14.0 KB
[TutsNode.com] - Excel Automation Using Python/6. Visualization/6. Hands on With Matplotlib OO Interface - II.srt 13.3 KB
[TutsNode.com] - Excel Automation Using Python/3. Pandas Intro/2.1 pd_series.py 751 bytes
[TutsNode.com] - Excel Automation Using Python/2. Numpy Intro/2. Numpy 1d Arrays.srt 13.2 KB
[TutsNode.com] - Excel Automation Using Python/5. Implementing Excel Functions in Python/4. Pivot Table - II.srt 13.0 KB
[TutsNode.com] - Excel Automation Using Python/6. Visualization/3. Pandas Visualization.srt 13.0 KB
[TutsNode.com] - Excel Automation Using Python/3. Pandas Intro/3.2 pd_df_intro.py 935 bytes
[TGx]Downloaded from torrentgalaxy.to .txt 585 bytes
[TutsNode.com] - Excel Automation Using Python/1. Introduction/4. Creating Virtual Environment (Optional).srt 12.8 KB
[TutsNode.com] - Excel Automation Using Python/1. Introduction/3. Anaconda Distribution Introduction.srt 12.1 KB
[TutsNode.com] - Excel Automation Using Python/3. Pandas Intro/4.2 pd_df_impexp.py 954 bytes
[TutsNode.com] - Excel Automation Using Python/4. OS Interaction Using Python/3. File Handling using Python.srt 11.4 KB
[TutsNode.com] - Excel Automation Using Python/2. Numpy Intro/3. Higher Dimensional Arrays.srt 11.3 KB
[TutsNode.com] - Excel Automation Using Python/3. Pandas Intro/5.1 pd_df_dtype.py 816 bytes
[TutsNode.com] - Excel Automation Using Python/5. Implementing Excel Functions in Python/9. String Manipulation in Python.srt 11.3 KB
[TutsNode.com] - Excel Automation Using Python/4. OS Interaction Using Python/2. Python OS Library.srt 11.3 KB
[TutsNode.com] - Excel Automation Using Python/3. Pandas Intro/6.1 pd_df_nan.py 629 bytes
[TutsNode.com] - Excel Automation Using Python/5. Implementing Excel Functions in Python/11. Assignment Solution - SUMIF(s) and COUNTIF(s).srt 11.2 KB
[TutsNode.com] - Excel Automation Using Python/2. Numpy Intro/1. What & Why of Numpy and Pandas.srt 10.9 KB
[TutsNode.com] - Excel Automation Using Python/3. Pandas Intro/7.1 pd_df_combine.py 1.0 KB
[TutsNode.com] - Excel Automation Using Python/5. Implementing Excel Functions in Python/2. Vlookup - II.srt 10.8 KB
[TutsNode.com] - Excel Automation Using Python/3. Pandas Intro/2. Pandas Series.srt 10.6 KB
[TutsNode.com] - Excel Automation Using Python/3. Pandas Intro/8.1 pd_groupby.py 646 bytes
[TutsNode.com] - Excel Automation Using Python/1. Introduction/1. Excel vs Python.srt 10.0 KB
[TutsNode.com] - Excel Automation Using Python/5. Implementing Excel Functions in Python/10. Assignment - SUMIF(s) and COUNTIF(s).srt 9.9 KB
[TutsNode.com] - Excel Automation Using Python/5. Implementing Excel Functions in Python/8. Text Manipulation in Excel.srt 9.7 KB
[TutsNode.com] - Excel Automation Using Python/6. Visualization/1. Excel Visualization.srt 9.3 KB
[TutsNode.com] - Excel Automation Using Python/4. OS Interaction Using Python/8. Assignment Solution - Consolidating files.srt 8.7 KB
[TutsNode.com] - Excel Automation Using Python/3. Pandas Intro/10.1 np_assignment.py 814 bytes
[TutsNode.com] - Excel Automation Using Python/1. Introduction/2. Course Objectives & Prerequisites.srt 8.3 KB
[TutsNode.com] - Excel Automation Using Python/6. Visualization/2. Python Visualization Intro.srt 7.1 KB
[TutsNode.com] - Excel Automation Using Python/5. Implementing Excel Functions in Python/5. Pivot Table - III.srt 6.5 KB
[TutsNode.com] - Excel Automation Using Python/5. Implementing Excel Functions in Python/7. IF Function - II.srt 6.5 KB
[TutsNode.com] - Excel Automation Using Python/4. OS Interaction Using Python/4. Python Glob Library and Handling Filenames.srt 6.3 KB
[TutsNode.com] - Excel Automation Using Python/3. Pandas Intro/12.1 pd_assignment.py 868 bytes
[TutsNode.com] - Excel Automation Using Python/5. Implementing Excel Functions in Python/6. IF Function - I.srt 5.5 KB
[TutsNode.com] - Excel Automation Using Python/6. Visualization/10. Visualization Assignment 1.srt 5.3 KB
[TutsNode.com] - Excel Automation Using Python/4. OS Interaction Using Python/1. How Do We Interact With OS.srt 5.4 KB
[TutsNode.com] - Excel Automation Using Python/6. Visualization/4. Matplotlib Object Oriented Interface.srt 4.7 KB
[TutsNode.com] - Excel Automation Using Python/4. OS Interaction Using Python/2.1 os_intro.py 633 bytes
[TutsNode.com] - Excel Automation Using Python/3. Pandas Intro/9. Numpy Assignment.srt 4.6 KB
[TutsNode.com] - Excel Automation Using Python/5. Implementing Excel Functions in Python/3. Pivot Table - I.srt 4.6 KB
[TutsNode.com] - Excel Automation Using Python/4. OS Interaction Using Python/3.1 file_handling.py 1.2 KB
[TutsNode.com] - Excel Automation Using Python/3. Pandas Intro/11. Pandas Assignment.srt 3.1 KB
[TutsNode.com] - Excel Automation Using Python/6. Visualization/13. Visualization Assignment 2.srt 2.2 KB
[TutsNode.com] - Excel Automation Using Python/4. OS Interaction Using Python/4.1 glob_intro.py 562 bytes
[TutsNode.com] - Excel Automation Using Python/4. OS Interaction Using Python/5. Assignment - Organize Your Files Using Python.srt 2.0 KB
[TutsNode.com] - Excel Automation Using Python/6. Visualization/14.1 assignment2.py 1.4 KB
[TutsNode.com] - Excel Automation Using Python/5. Implementing Excel Functions in Python/5.1 pivot_tbl_pd.py 1.4 KB
[TutsNode.com] - Excel Automation Using Python/6. Visualization/12.1 assignment1_2.py 1.3 KB
[TutsNode.com] - Excel Automation Using Python/4. OS Interaction Using Python/6.1 assignment1.py 515 bytes
[TutsNode.com] - Excel Automation Using Python/4. OS Interaction Using Python/7. Assignment - Consolidate Numerous Files from Various Locations.srt 1.3 KB
[TutsNode.com] - Excel Automation Using Python/6. Visualization/7.1 plt_oo_3.py 1.3 KB
[TutsNode.com] - Excel Automation Using Python/6. Visualization/9.1 df_plot_oo_2.py 1.1 KB
[TutsNode.com] - Excel Automation Using Python/5. Implementing Excel Functions in Python/4.1 pivot_tbl.py 1.1 KB
[TutsNode.com] - Excel Automation Using Python/4. OS Interaction Using Python/8.1 assignment2.py 582 bytes
[TutsNode.com] - Excel Automation Using Python/5. Implementing Excel Functions in Python/2.1 vlookup_fn.py 1.0 KB
[TutsNode.com] - Excel Automation Using Python/6. Visualization/11.1 assignment1_1.py 985 bytes
[TutsNode.com] - Excel Automation Using Python/6. Visualization/3.1 df_plot.py 955 bytes
[TutsNode.com] - Excel Automation Using Python/5. Implementing Excel Functions in Python/1.2 vlookup.py 689 bytes
[TutsNode.com] - Excel Automation Using Python/5. Implementing Excel Functions in Python/11.1 sumif_countif.py 922 bytes
[TutsNode.com] - Excel Automation Using Python/5. Implementing Excel Functions in Python/9.1 string_fn.py 896 bytes
[TutsNode.com] - Excel Automation Using Python/6. Visualization/8.1 df_plot_oo_1.py 811 bytes
[TutsNode.com] - Excel Automation Using Python/5. Implementing Excel Functions in Python/7.1 if_fn.py 647 bytes
[TutsNode.com] - Excel Automation Using Python/6. Visualization/6.1 plt_oo_2.py 631 bytes
[TutsNode.com] - Excel Automation Using Python/6. Visualization/5.1 plt_oo_1.py 625 bytes
.pad/0 27.3 KB
[TutsNode.com] - Excel Automation Using Python/3. Pandas Intro/7. Combining DataFrames (Concatenate, Merge & Join).mp4 201.1 MB
.pad/1 896.1 KB
[TutsNode.com] - Excel Automation Using Python/5. Implementing Excel Functions in Python/1. Vlookup - I.mp4 196.5 MB
.pad/2 467.5 KB
[TutsNode.com] - Excel Automation Using Python/6. Visualization/12. Visualization Assignment 1 Solution - II.mp4 184.8 MB
.pad/3 246.7 KB
[TutsNode.com] - Excel Automation Using Python/6. Visualization/14. Visualization Assignment 2 Solution.mp4 147.6 MB
.pad/4 373.1 KB
[TutsNode.com] - Excel Automation Using Python/6. Visualization/9. Combining Pandas Visualization with OO Capabilities - II.mp4 145.1 MB
.pad/5 944.3 KB
[TutsNode.com] - Excel Automation Using Python/3. Pandas Intro/12. Pandas Assignment Solution.mp4 142.2 MB
.pad/6 845.5 KB
[TutsNode.com] - Excel Automation Using Python/3. Pandas Intro/10. Numpy Assignment Solution.mp4 130.4 MB
.pad/7 624.8 KB
[TutsNode.com] - Excel Automation Using Python/3. Pandas Intro/6. Handling NaN Values.mp4 119.2 MB
.pad/8 810.6 KB
[TutsNode.com] - Excel Automation Using Python/3. Pandas Intro/3. Pandas Dataframe.mp4 114.9 MB
.pad/9 151.1 KB
[TutsNode.com] - Excel Automation Using Python/6. Visualization/11. Visualization Assignment 1 Solution - I.mp4 114.4 MB
.pad/10 616.9 KB
[TutsNode.com] - Excel Automation Using Python/6. Visualization/5. Hands on With Matplotlib OO Interface - I.mp4 113.5 MB
.pad/11 505.7 KB
[TutsNode.com] - Excel Automation Using Python/5. Implementing Excel Functions in Python/8. Text Manipulation in Excel.mp4 112.6 MB
.pad/12 451.3 KB
[TutsNode.com] - Excel Automation Using Python/2. Numpy Intro/4. Numpy Operations.mp4 111.3 MB
.pad/13 667.1 KB
[TutsNode.com] - Excel Automation Using Python/3. Pandas Intro/8. Data AggregationSummarization using Groupby.mp4 111.1 MB
.pad/14 925.4 KB
[TutsNode.com] - Excel Automation Using Python/3. Pandas Intro/5. Handling PythonDataframe Data Types.mp4 108.0 MB
.pad/15 38.1 KB
[TutsNode.com] - Excel Automation Using Python/5. Implementing Excel Functions in Python/10. Assignment - SUMIF(s) and COUNTIF(s).mp4 105.6 MB
.pad/16 408.9 KB
[TutsNode.com] - Excel Automation Using Python/6. Visualization/7. Hands on With Matplotlib OO Interface - III.mp4 102.4 MB
.pad/17 635.9 KB
[TutsNode.com] - Excel Automation Using Python/5. Implementing Excel Functions in Python/4. Pivot Table - II.mp4 98.6 MB
.pad/18 413.9 KB
[TutsNode.com] - Excel Automation Using Python/6. Visualization/8. Combining Pandas Visualization with OO Capabilities - I.mp4 97.6 MB
.pad/19 442.5 KB
[TutsNode.com] - Excel Automation Using Python/2. Numpy Intro/5. Indexing and Slicing.mp4 88.2 MB
.pad/20 783.1 KB
[TutsNode.com] - Excel Automation Using Python/6. Visualization/1. Excel Visualization.mp4 80.9 MB
.pad/21 143.8 KB
[TutsNode.com] - Excel Automation Using Python/1. Introduction/4. Creating Virtual Environment (Optional).mp4 80.8 MB
.pad/22 181.0 KB
[TutsNode.com] - Excel Automation Using Python/3. Pandas Intro/1. The Power of Pandas (Teaser Video).mp4 79.3 MB
.pad/23 736.4 KB
[TutsNode.com] - Excel Automation Using Python/4. OS Interaction Using Python/6. Assignment Solution - Organizing Files.mp4 77.8 MB
.pad/24 168.3 KB
[TutsNode.com] - Excel Automation Using Python/6. Visualization/3. Pandas Visualization.mp4 75.8 MB
.pad/25 177.8 KB
[TutsNode.com] - Excel Automation Using Python/5. Implementing Excel Functions in Python/11. Assignment Solution - SUMIF(s) and COUNTIF(s).mp4 72.6 MB
.pad/26 397.4 KB
[TutsNode.com] - Excel Automation Using Python/6. Visualization/6. Hands on With Matplotlib OO Interface - II.mp4 70.5 MB
.pad/27 464.5 KB
[TutsNode.com] - Excel Automation Using Python/4. OS Interaction Using Python/3. File Handling using Python.mp4 70.3 MB
.pad/28 672.4 KB
[TutsNode.com] - Excel Automation Using Python/2. Numpy Intro/2. Numpy 1d Arrays.mp4 68.0 MB
.pad/29 1008.4 KB
[TutsNode.com] - Excel Automation Using Python/5. Implementing Excel Functions in Python/9. String Manipulation in Python.mp4 67.0 MB
.pad/30 983.4 KB
[TutsNode.com] - Excel Automation Using Python/2. Numpy Intro/3. Higher Dimensional Arrays.mp4 66.4 MB
.pad/31 657.2 KB
[TutsNode.com] - Excel Automation Using Python/5. Implementing Excel Functions in Python/2. Vlookup - II.mp4 65.0 MB
.pad/32 8.8 KB
[TutsNode.com] - Excel Automation Using Python/2. Numpy Intro/1. What & Why of Numpy and Pandas.mp4 62.7 MB
.pad/33 323.8 KB
[TutsNode.com] - Excel Automation Using Python/3. Pandas Intro/2. Pandas Series.mp4 60.2 MB
.pad/34 847.7 KB
[TutsNode.com] - Excel Automation Using Python/5. Implementing Excel Functions in Python/6. IF Function - I.mp4 58.7 MB
.pad/35 312.1 KB
[TutsNode.com] - Excel Automation Using Python/1. Introduction/3. Anaconda Distribution Introduction.mp4 56.7 MB
.pad/36 259.9 KB
[TutsNode.com] - Excel Automation Using Python/4. OS Interaction Using Python/2. Python OS Library.mp4 54.3 MB
.pad/37 737.9 KB
[TutsNode.com] - Excel Automation Using Python/5. Implementing Excel Functions in Python/5. Pivot Table - III.mp4 54.1 MB
.pad/38 875.2 KB
[TutsNode.com] - Excel Automation Using Python/4. OS Interaction Using Python/8. Assignment Solution - Consolidating files.mp4 51.2 MB
.pad/39 799.7 KB
[TutsNode.com] - Excel Automation Using Python/1. Introduction/1. Excel vs Python.mp4 45.9 MB
.pad/40 98.1 KB
[TutsNode.com] - Excel Automation Using Python/4. OS Interaction Using Python/1. How Do We Interact With OS.mp4 43.0 MB
.pad/41 1000.4 KB
[TutsNode.com] - Excel Automation Using Python/5. Implementing Excel Functions in Python/3. Pivot Table - I.mp4 41.0 MB
.pad/42 983.4 KB
[TutsNode.com] - Excel Automation Using Python/5. Implementing Excel Functions in Python/7. IF Function - II.mp4 39.3 MB
.pad/43 696.6 KB
[TutsNode.com] - Excel Automation Using Python/3. Pandas Intro/11. Pandas Assignment.mp4 37.9 MB
.pad/44 146.5 KB
[TutsNode.com] - Excel Automation Using Python/4. OS Interaction Using Python/4. Python Glob Library and Handling Filenames.mp4 34.5 MB
.pad/45 475.1 KB
[TutsNode.com] - Excel Automation Using Python/3. Pandas Intro/3.1 flight_data.csv 29.3 MB
.pad/46 680.6 KB
[TutsNode.com] - Excel Automation Using Python/3. Pandas Intro/9. Numpy Assignment.mp4 28.3 MB
.pad/47 674.8 KB
[TutsNode.com] - Excel Automation Using Python/6. Visualization/10. Visualization Assignment 1.mp4 28.3 MB
.pad/48 766.0 KB
[TutsNode.com] - Excel Automation Using Python/1. Introduction/2. Course Objectives & Prerequisites.mp4 26.4 MB
.pad/49 604.7 KB
[TutsNode.com] - Excel Automation Using Python/6. Visualization/2. Python Visualization Intro.mp4 25.2 MB
.pad/50 818.8 KB
[TutsNode.com] - Excel Automation Using Python/6. Visualization/4. Matplotlib Object Oriented Interface.mp4 21.7 MB
.pad/51 319.4 KB
[TutsNode.com] - Excel Automation Using Python/4. OS Interaction Using Python/5. Assignment - Organize Your Files Using Python.mp4 14.0 MB
.pad/52 22.8 KB
[TutsNode.com] - Excel Automation Using Python/6. Visualization/13. Visualization Assignment 2.mp4 8.4 MB
.pad/53 570.5 KB
[TutsNode.com] - Excel Automation Using Python/4. OS Interaction Using Python/7. Assignment - Consolidate Numerous Files from Various Locations.mp4 5.1 MB
.pad/54 917.9 KB
[TutsNode.com] - Excel Automation Using Python/5. Implementing Excel Functions in Python/1.1 zipcode_income.csv 4.8 MB
.pad/55 204.9 KB
[TutsNode.com] - Excel Automation Using Python/3. Pandas Intro/4.1 data.xlsx 2.1 MB
.pad/56 914.4 KB
[TutsNode.com] - Excel Automation Using Python/3. Pandas Intro/11.1 sales_data.xlsx 1.3 MB

Details for: Udemy - Excel Automation Using Python

udemy excel automation using python

Similar Posts: