About
About Us
Help
Privacy Policy
Terms of Service
LearnDesk
Learn
Academics
Business
Creative
Health and Fitness
Lifestyle
Personal Development
Software
Topics
Admissions
Engineering
Hardware
Hospitality
Humanities
Chinese
Languages
Maths
Pharma
View All Topics
Topics
Accounting
Advertising
Analysis
Analytics
Business Communication
eCommerce
Entrepreneurship
Finance
Finance - India
Freelancing
View All Topics
Topics
Arts & Crafts
Audio Editing
Audio Production
Dance
Design
Film Production
Music
Photography
Video Production
Writing
View All Topics
Topics
Dieting
Fitness
Food Safety
Games
Medical
Medical Professionals
Meditation
Mental Health
Pregnancy
Safety & First Aid
View All Topics
Topics
Beauty & Makeup
Food
Fashion
Gaming
Home Improvement
Parenting
Pet Care & Training
Relationships
Sustainable Living
View All Topics
Topics
Career Development
Learning
Religion and Spirituality
Self-Improvement
View All Topics
Topics
Accounting
Amazon Web Services
App Development
Continuous Integration
Backup Software
Business Automation
Computational Fluid Dynamics
Business Intelligence
Computer Aided Design (CAD)
View All Topics
Teach
Teach Online
Schedule
Items
Billing
Users
Marketing
Analytics
Settings
Change School
Account
Log In
Sign Up
Python 3: Automating Your Job Tasks
Introduction - What's This Course All About?
What Will You Learn?
Preview
General Recap: Python 3 - Cheat Sheet and 200+ Pages E-Book
Python 3 - Cheat Sheet
Python 3 - 200+ Pages E-book
Superhero Level: Automate Excel Tasks with Python 3
Setting Up the Working Environment
Download the sample Excel file
Loading an Excel Workbook In Python and Creating/Removing Sheets
Notebook - Handling Workbooks
Getting General Information About a Sheet
Notebook - Sheet Information
Working with Sheet Cells Using Python
Notebook - Cell Information
Working with Cell Styles Using Python
Notebook - Cell Styles
Download the Excel-Python Cheat Sheet
APPLICATION - Migrating Records from a Text File to an Excel Workbook
Download the Code - Excel Application
Useful Links
Superhero Level: Automate Database Tasks with Python 3
Installing the Database Server Software
Downloading and Installing PostgreSQL on Windows, Linux, macOS
Installing the Necessary Python Module
Creating a New Database, Schema and User
Notebook - Creating a New Database, Schema and User
Connecting Python to the Database
Notebook - Connecting Python to the Database
Creating Database Tables with Python
Notebook - Creating Database Tables with Python
Inserting Records Into a Table with Python
Notebook - Inserting Records Into a Table with Python
Updating Records Into a Table with Python
Notebook - Updating Records Into a Table with Python
Deleting Records From a Table with Python
Notebook - Deleting Records From a Table with Python
Querying the Database with Python
Notebook - Querying the Database with Python
Fetching Information From the Database with Python
Notebook - Fetching Information From the Database with Python
Committing and Rolling Back Transactions with Python
Notebook - Committing and Rolling Back Transactions
Download the PostgreSQL Syntax Cheat Sheet
Download the PostgreSQL-Python Cheat Sheet
APPLICATION - Migrating Records from a Text File to the Database
Download the Code - Database Application
Useful Links
Superhero Level: Automate Network Tasks with Python 3
Network Setup Overview
Installing the Virtualization Software
Installing the Virtualization Software on Windows, Linux, macOS
Downloading & Installing the Network Device VM
Signing Up to the Arista Software Download Portal
Importing the VM & Tweaking the VM Settings
Connecting the Local PC to the Devices in Windows
Connecting the Local PC to the Devices in macOS
Checking the SSH Configuration and Testing the Connectivity
Necessary Switch/Router Configuration
Any Connection Issues? Check Out This Troubleshooting Checklist!
Planning the Application
Checking IP File Validity
Notebook - Checking IP File Validity
Checking IP Address Validity
Notebook - Checking IP Address Validity
Checking IP Address Reachability
Notebook - Checking IP Address Reachability
Note about pinging in Windows vs. Mac OS / Linux
Checking Username/Password File Validity
Notebook - Checking Username/Password File Validity
Checking Command File Validity
Notebook - Checking Command File Validity
Establishing the SSH Connection
Notebook - Establishing the SSH Connection
Enabling Simultaneous SSH Connections
Notebook - Enabling Simultaneous SSH Connections
APPLICATION - Putting Everything Together
Download the Code - Network Application and Modules
Reading Device Configuration
Extracting Network Parameters
Configuring Multiple Devices Simultaneously
Useful Links
Superhero Level: Automate Data Analysis Tasks with Python 3
Running Python Code - The Next Level: IPython and Jupyter Notebook
Notebook - IPython and Jupyter Notebook
Introduction to Pandas - Basic Operations
Notebook - Introduction to Pandas
Handling Files with Pandas - TXT, CSV, JSON, XLSX
Download the necessary files
Notebook - Handling TXT, CSV, JSON, XLSX Files with Pandas
Reading HTML Content from URLs and HTML Files with Pandas
Notebook - Reading HTML Content with Pandas
Indexing and Slicing Tables with Pandas
Notebook - Indexing and Slicing Tables with Pandas
Adding, Updating, Deleting Table Rows and Columns
Notebook - Adding, Updating, Deleting Table Rows and Columns
APPLICATION - Reading and Writing Data in PostgreSQL Databases Using Pandas
Download the Code - SQL Data Analysis Application
Useful Links
Superhero Level: Data Visualization with Bokeh and Python 3
Introduction to Bokeh
Bookmark These 3 Important Documentation Links
Creating a Basic Line Plot Based on Python Lists
Notebook - Creating a Basic Line Plot Based on Python Lists
Creating a Bar Plot Based on Excel Data
Download the necessary XSLX file
Notebook - Creating a Bar Plot Based on Excel Data
Creating a Pie Chart Based on CSV Data
Download the necessary CSV file
Notebook - Creating a Pie Chart Based on CSV Data
Plotting Multiple Stock Prices Simultaneously
Notebook - Plotting Multiple Stock Prices Simultaneously
Plotting Bitcoin Prices as an Interactive Plot with a Range Tool
Notebook - Plotting Bitcoin Prices as an Interactive Plot with a Range Tool
Plotting Bitcoin Prices as an Interactive Plot with Candlesticks
Notebook - Plotting Bitcoin Prices as an Interactive Plot with Candlesticks
Useful Links
Superhero Level: Automate Unit Testing with Python 3
Installing pytest and Writing Your First Test
Notebook - Introduction to pytest
Running Multiple Tests. Test Discovery Rules in Action
Notebook - Running Multiple Tests
Testing a Basic Script - Preparing the Test Bed
Download the Code for Testing
Fixture Functions
Notebook - Fixture Functions
Sharing a Fixture Instance & Fixture Finalization
Notebook - Sharing a Fixture Instance & Fixture Finalization
Parametrizing Fixtures
Notebook - Parametrizing Fixtures
Marking Test Functions Using Attributes
Notebook - Marking Test Functions Using Attributes
Marking Test Functions Using Custom Markers
Notebook - Marking Test Functions Using Custom Markers
Useful Links
Superhero Level: Automate Web Scraping with Python 3
Installing the Necessary Modules
Notebook - Installing the Necessary Modules
Extracting and Parsing Web Content
Notebook - Extracting and Parsing Web Content
Tags, Names and Attributes
Notebook - Tags, Names and Attributes
Searching the Tree of HTML Tags: find() and find_all()
Notebook - Searching the Tree of HTML Tags: find() and find_all()
APPLICATION - Extracting the Product Names, Links and Prices. Saving to Excel
Download the Code - Scraping Web Data and Saving to Excel
APPLICATION - Handling Website Pagination When Extracting Data
Download the Code - Handling Website Pagination When Extracting Data
Useful Links
Notebook - Reading HTML Content with Pandas
Python 3: Automating Your Job Tasks
Superhero Level: Automate Data Analysis Tasks with Python 3
By:
Mihai Catalin Teodosiu
Share
Share the link to this page
Copied
Facebook
Twitter
WhatsApp
LinkedIn
Email
Add to Calendar
Add the class to your calendar
Add to Google Calendar
Add to Apple Calendar
Add to Yahoo Calendar
Add to Outlook Calendar
Print
Completed
You need to have access to the item to view this lesson.
One-time Fee
$99.99
List Price:
$139.99
You save:
$40
Buy Class
€92.78
List Price:
€129.90
You save:
€37.11
Buy Class
£79.40
List Price:
£111.16
You save:
£31.76
Buy Class
CA$136.11
List Price:
CA$190.56
You save:
CA$54.44
Buy Class
A$154.13
List Price:
A$215.78
You save:
A$61.65
Buy Class
S$135.08
List Price:
S$189.12
You save:
S$54.03
Buy Class
HK$782.28
List Price:
HK$1,095.23
You save:
HK$312.94
Buy Class
CHF 90.61
List Price:
CHF 126.85
You save:
CHF 36.24
Buy Class
NOK kr1,085.23
List Price:
NOK kr1,519.37
You save:
NOK kr434.13
Buy Class
DKK kr692.01
List Price:
DKK kr968.84
You save:
DKK kr276.83
Buy Class
NZ$167.80
List Price:
NZ$234.94
You save:
NZ$67.13
Buy Class
د.إ367.19
List Price:
د.إ514.08
You save:
د.إ146.89
Buy Class
৳10,976.08
List Price:
৳15,366.96
You save:
৳4,390.87
Buy Class
₹8,339.52
List Price:
₹11,675.66
You save:
₹3,336.14
Buy Class
RM473.25
List Price:
RM662.57
You save:
RM189.32
Buy Class
₦141,842.81
List Price:
₦198,585.61
You save:
₦56,742.80
Buy Class
₨27,810.04
List Price:
₨38,935.18
You save:
₨11,125.13
Buy Class
฿3,647.70
List Price:
฿5,106.92
You save:
฿1,459.22
Buy Class
₺3,232.12
List Price:
₺4,525.11
You save:
₺1,292.98
Buy Class
B$499.21
List Price:
B$698.91
You save:
B$199.70
Buy Class
R1,908.54
List Price:
R2,672.04
You save:
R763.49
Buy Class
Лв180.65
List Price:
Лв252.92
You save:
Лв72.26
Buy Class
₩135,197.71
List Price:
₩189,282.20
You save:
₩54,084.49
Buy Class
₪368.63
List Price:
₪516.10
You save:
₪147.47
Buy Class
₱5,633.91
List Price:
₱7,887.71
You save:
₱2,253.79
Buy Class
¥15,144.47
List Price:
¥21,202.86
You save:
¥6,058.39
Buy Class
MX$1,659.40
List Price:
MX$2,323.22
You save:
MX$663.82
Buy Class
QR364.31
List Price:
QR510.04
You save:
QR145.73
Buy Class
P1,370.91
List Price:
P1,919.33
You save:
P548.42
Buy Class
KSh13,148.68
List Price:
KSh18,408.68
You save:
KSh5,260
Buy Class
E£4,729.52
List Price:
E£6,621.52
You save:
E£1,892
Buy Class
ብር5,680.63
List Price:
ብር7,953.11
You save:
ብር2,272.48
Buy Class
Kz83,612.74
List Price:
Kz117,061.18
You save:
Kz33,448.44
Buy Class
CLP$97,978.20
List Price:
CLP$137,173.40
You save:
CLP$39,195.20
Buy Class
CN¥722.95
List Price:
CN¥1,012.16
You save:
CN¥289.21
Buy Class
RD$5,921.50
List Price:
RD$8,290.34
You save:
RD$2,368.83
Buy Class
DA13,490.83
List Price:
DA18,887.70
You save:
DA5,396.87
Buy Class
FJ$226.12
List Price:
FJ$316.58
You save:
FJ$90.46
Buy Class
Q779.86
List Price:
Q1,091.83
You save:
Q311.97
Buy Class
GY$20,923.51
List Price:
GY$29,293.76
You save:
GY$8,370.24
Buy Class
ISK kr13,946.60
List Price:
ISK kr19,525.80
You save:
ISK kr5,579.20
Buy Class
DH1,013.19
List Price:
DH1,418.51
You save:
DH405.32
Buy Class
L1,763.34
List Price:
L2,468.75
You save:
L705.40
Buy Class
ден5,702.11
List Price:
ден7,983.18
You save:
ден2,281.07
Buy Class
MOP$805.89
List Price:
MOP$1,128.28
You save:
MOP$322.39
Buy Class
N$1,893.44
List Price:
N$2,650.90
You save:
N$757.45
Buy Class
C$3,681.15
List Price:
C$5,153.75
You save:
C$1,472.60
Buy Class
रु13,335.63
List Price:
रु18,670.42
You save:
रु5,334.78
Buy Class
S/370.84
List Price:
S/519.19
You save:
S/148.35
Buy Class
K382.72
List Price:
K535.82
You save:
K153.10
Buy Class
SAR375
List Price:
SAR525.01
You save:
SAR150.01
Buy Class
ZK2,522.76
List Price:
ZK3,531.96
You save:
ZK1,009.20
Buy Class
L461.43
List Price:
L646.02
You save:
L184.59
Buy Class
Kč2,350.75
List Price:
Kč3,291.15
You save:
Kč940.39
Buy Class
Ft36,729.02
List Price:
Ft51,422.10
You save:
Ft14,693.08
Buy Class
SEK kr1,071.30
List Price:
SEK kr1,499.86
You save:
SEK kr428.56
Buy Class
ARS$85,766.82
List Price:
ARS$120,076.98
You save:
ARS$34,310.16
Buy Class
Bs691.04
List Price:
Bs967.48
You save:
Bs276.44
Buy Class
COP$387,583.68
List Price:
COP$542,632.66
You save:
COP$155,048.97
Buy Class
₡50,832.34
List Price:
₡71,167.31
You save:
₡20,334.97
Buy Class
L2,468.78
List Price:
L3,456.40
You save:
L987.61
Buy Class
₲737,805.73
List Price:
₲1,032,957.54
You save:
₲295,151.80
Buy Class
$U3,781.90
List Price:
$U5,294.82
You save:
$U1,512.91
Buy Class
zł400.73
List Price:
zł561.05
You save:
zł160.31
Buy Class
Already have an account?
Log In
Previous
Next
Sign Up
Signup to access thousands of classes
Continue with Facebook
Continue with Google
OR
Continue with Email
Already a member?
Log In
By registering for a LearnDesk account, you agree to our
Terms of Service
and
Privacy Policy
.
Share
Share with friends, get 20% off
Invite your friends to LearnDesk learning marketplace. For each purchase they make, you get 20% off (upto $10) on your next purchase.
Share with Google Contacts