Python is a very popular language for data analysis and data manipulation. Furthermore, Python has a lot of libraries to manipulate Excel data. In this post, I will explain how to write to and read from Excel sheet using Python’s script . Which will be very useful for you to learn data science and Artificial […]
Writing and Reading Excel Data from Python Read More »
Not only variables but a list can also be passed and manipulated in a Python’s function. If you want to read about function read the post User Defined Functions in Python and want to know about list see post List in Python . Further, I will demonstrate how to pass a list as
Passing a List in a Function in Python Read More »
Microsoft Excel is a very popular spreadsheet program which is easy to use and it has a lot formulas which are related to finance, statistics, logical and arithmetic etc.. Furthermore, this is very popular among those who are working in office, in the field finance, administration and management. In this post, I will demonstrate how
Addition In Microsoft Excel Read More »
If value of a parameter is already known then you can assign default values to a Python function’s parameter. Further, the default values can be specified in the function header. For example, def sum(x, y, z=15): s=x+y+z return s In the above program, value of parameter z is 15. If in program, function call sum(20,
Default Arguments in Python Functions Read More »
Time and date datatypes and functions in SQL play very important role in DBMS (Database Management Systems). Such as, transaction management, or admission time of a student, time of product purchase and many more cases where time and date datatypes and functions becomes essential. In this post, I will explain time and date datatypes and
Time and Date Datatypes and Functions in SQL Read More »
Array in PHP- In PHP, there are three types of arrays , and array() function is used to create an array in PHP. 1- Indexed or Numeric Array- In a numeric or an indexed array elements of an array are indexed with numeric values. For example, if you define an array ar with the elements
See Also: Time and Date Datatypes and Functions in SQL Create a Table in SQL and Select Data from Table Update Command in Structured Query Language (SQL) BETWEEN, NOT BETWEEN, IN and NOT IN Operators in SQL Create Table Insert Data Into Table and Select Data in SQL
ORDER BY Keyword in SQL Read More »
In the previous post Create Table Insert Data Into Table and Select Data in SQL, you have learnt how to create a table, insert data into it and select rows and columns from table. In this post, you will learn how to use BETEEN, NOT BETWEEN, IN and NOT IN operators
BETWEEN, NOT BETWEEN, IN and NOT IN Operators in SQL Read More »
Structured Query Language (SQL) is standard language to manipulate databases. MySQL, MariaDB, MS-Access and all popular Database Management System software use SQL. In this post, I will demonstrate how to create a table, insert data into table and select columns and rows. In this example, I will example of class table of school database. So,
Create Table Insert Data Into Table and Select Data in SQL Read More »
Dictionary in Python is a very important data-structure which can have elements in the form of of key value pairs key:value. Moreover, dictionary also provides different methods to manipulate. In this post, I will explain methods which will work on dictionary. If you use print(dir(dict)) Then you will see the output. The above output
Dictionary Methods in Python Read More »