An intro Course illustrating SQL equivalents in Python
Requirements
Basic Knowledge of Python
Description
Overview
In this course you will learn how to use the Python Pandas library to achieve the core SQL functionality listed below.
If you are ready to make the leap from SQL to Python, this course will help you through your adoption and increased usage of Python for data manipulation, transformation and ultimately data analysis.
Understanding how to achieve SQL data manipulation features in Python will serve as your foundation for using Python for advanced analysts, data science and other machine learning tasks.
Prerequisites
This course is recommended for anyone who is comfortable with SQL and would like to increase their adoption of Python for their day to day. It’s also recommended that you have a base understanding of Python or some familiarity of any programming language in order to get the most of this course. Other prerequisites will be outlined in the Introduction video, but having the following set up on your computer ahead of time will allow you to dive right in.
Python 3.7 or above installed
pandas library installed (pip install pandas)
IDE (e.g. PyCharm, VS Code)
Git (optional, for cloning repo with code examples)
Core Concepts taught in this course
Core SQL Concepts translated to Python Pandas code are:
SQL Limit
SQL Distinct
SQL Where
SQL WHERE / AND (Multiple Predicates)
SQL IN ( )
SQL NOT IN ( )
SQL Aggregate Functions
SQL MIN
SQL MAX
SQL COUNT
SQL COUNT DISTINCT
SQL AVERAGE / MEAN
Mode (Not usually available in most SQL databases)
Learn the step by step Installation process of Python & Pycharm IDE in detailed
Requirements
Computer with internet connection
Description
Hi and welcome to this course,
Python is one of the most popular programming languages in the world, huge companies like google uses it for google search engines and in mission critical applications.
And python is the No 1 Programming language and a great choice for machine learning, data science and AI. To get high paying jobs and to boost up your career, Python is a good option for you.
In this course you will learn how to get started with Python and how to easily install and setup Python on your laptop irrespective on the operating system you use.
In this course you are going to start with downloading process and learn how to find right python version for your OS.
we not only install python, once we are done installing we are going to test the installation process as well by writing a sample python program.
– Python installation on window
– Testing the installation process on Windows Command prompt
– Python installation on Mac OS
– Testing the installation process on Mac Terminal
Disclaimer :Downloaded Lectures are only for reference do not use them or share them to others or do not use for commercial purposes, any miss-use of Course Data & Lectures is a punishable offence & illegal and would be prosecuted legally.
Who this course is for:
Beginners or Freshers to Programming language or Python
Learn how to install Virtualenv and Virtualenvwrapper
Learn how to install Pycharm (Python IDE)
Learn how to install required libraries and applications
Learn how to convert text to speech using Python
Requirements
Applicants must have a level of Python programming above beginner
There is no need for mathematics
Description
We are in the AI and robotics era.
Our mobile phones understand what we say and speak. Also new model computers can talk. Can we do something also? What not make our computer speak?
In this course, we will learn the basics of Text-to-Speech (TTS).
We will use Python 3.6. A little better than beginner level of programming skill will be enough.
We will study very simple coding examples. But you can improve the scripts easily.
In the course we will use Pycharm Community IDE. Of course, this is not a must! You can write your scripts in a terminal too.
Our main operating system is Ubuntu Linux, version 18.04 LTS. But, our Python scripts will be also compatible with Windows 10 and Mac OS X which can run Python 3.6.
At the last section of our course, I will show simply how to install required libraries and applications and run our Python scripts in both Windows and Mac.
After this course, I will publish a more advanced course on Speech-to-Text (STT). This course will be helpful for it.
I hope I can help you to start working on TTS and STT with Python.
Who this course is for:
Python programmers who want to write their own Text-to-Speech scripts
Python programmers who want to practice AI from the beginning and want to create their own bots
