Data Types – Commonly used¶ Python has several data types which are commonly used. There are advanced data types such as Data Frames as part of modules such as pandas.* Numeric – int, float, complex Alpha Numeric – str Boolean – bool (it will be covered in another topic) Collections list set dict tuple type(VARIABLE_NAME) …
Variables and Objects¶ Let us get an overview about variables and objects in Python. In Python we need not define data types for variables or objects.* Data types are inherited based up on the values assigned to the variables. We can check the type of the variable or object using type function. Python is interpreter …
Getting Help¶ We have already seen how to get help earlier. Let’s deep dive to understand more about getting help using Python.* We can get help either in Python CLI or Jupyter Notebook. Help can be launched by calling help() It will launch CLI and we can enter a class name or function name. We …
Basic Programming Constructs¶ As part of this section we will see basic programming constructs in Python. Getting Help Variables and Objects Data Types – Commonly used Operators in Python Comments and Doc Strings Conditionals All about for loops Running OS Commands
Filtering Data¶ Let us understand how we can filter the data as part of our queries. We use WHERE clause to filter the data. All comparison operators such as =, !=, >, <, <=, >= etc can be used to compare a column or expression or literal with another column or expression or literal. We …
Overview of Transactions¶ Let us go through the details related to Transactions.* We typically perform operations such as COMMIT and ROLLBACK via the applications. COMMIT will persist the changes in the database. ROLLBACK will revert the uncommitted changes in the database. We typically rollback the uncommitted changes in a transaction if there is any exception …
