Binary Files: In Python, a binary file is a file that contains textual and non-textual data, such as images, audio files, video files, and executable programs. Binary files are usually opened in binary mode to avoid any character encoding issues, and they can be read and written using the built-in file handling functions.1) It stores …
Text Files: In Python, a text file is a file that contains human-readable text. Text files are usually created with a text editor, and they can be read and written in Python using the built-in file handling functions.1) They store information in the form of ASCII/Unicode characters.2) Each line of text is terminated or delimited …
File: In Python, a file is a named area on disk or in memory used to store data permanently. A file can be used to store text, binary data, or other types of data. Python provides built-in functions and methods for working with files, which allows you to open, create, read, write, append, modify and …
CSV (Comma Separated Values) Files: CSV Files stores a tabular data that has been saved as a plaintext, where data is separated by commas. It follows two rules:1) Number of rows in CSV File = Number of rows in table2) Comma , appears after every field (except the last field) RollNo Name Marks 1 Sheetal …
Import Export Data between CSV files and Data Frame in Python Read More »
Library Needed: We need any one of the following library to connect to the MySQL database with Python.1) mysql.connector : It is a library provided by oracle2) pymysql : It is pure Python library. Steps of Connectivity:1) Start Python2) Import the required library.3) Open a Connection4) Create a cursor instance.5) Execute the SQL query.6) Extract …
Conditional Statements: It tests a condition and executes a particular statement or a group of statements depending upon the result of the condition. It is a compound statement i.e. it contains other statements. Python supports following types of conditional statements1) if2) if else3) if elif else4) Nested if else if statement: It tests a condition …
Input Statements in Python: We can read the variables by using python input() function as:1) We can write any string/text to be displayed at the python prompt as an argument to the input function.2) If we don’t specify any string/text to be displayed at the python prompt , then nothing will be displayed. But we …
Type Conversion: It means to convert the operands of one data type into another data type. Types of Conversions: Python supports two types of conversions:1) Implicit Type Promotion/ Internal Conversion 2) Explicit Type Casting/ External Conversion 1) Implicit Type Promotion/ Internal Conversion : It is the conversion done by the python compiler/interpreter without user’s intervention.1) …
Expressions: It is any valid combination of operators and operands (may be literals / variables). It is composed of one or more operations. Example 1) 5 + 4 is valid2) 5 + -4 is valid3) 5 + * 6 is invalid because in this case, compiler will be confused which operation whether + or * …
Statements Flow Control: It determines the order of execution of statements in a program. Types of Statements Flow Control: There are 3 types of flow control in python.1) Sequential Flow2) Conditional / Branching / Decision Making / Selection Statements3) Iteration/ Repetition/ Looping Statements 1) Sequential Flow: In it, statements are executed in sequence one after …