Suppose that in Python you want to expand an expression (x+y)2 to x2 + y2 + 2 xy, this can be done using sympy library in Python, first of all see a simple program. from sympy import * x = Symbol(‘x’) y = Symbol(‘y’) z=(x + y)**2 print(expand(z)) Output:- x**2 + 2*x*y + y**2 How […]
sympy Library in Python Read More »
COUNTIF() and SUMIF are very important functions in excel which are used to automate manual tasks. Furthermore, these functions are frequently used in finance and accounting. In this post, I am going to explain working of these two functions. COUNTIF() function- This function counts the values of a column when a condition if fulfilled
COUNTIF and SUMIF Functions in MS Excel Read More »
K-nearest neighbors algorithm is a machine learning algorithm which is used for classification and regression, and it can be applied where other machine learning algorithms are applied. See the typical problem setting , Suppose (x1, y1), (x2, y2), (x3, y3), ……………….(xn, yn) pairs in which x’s are attributes and y’s are labels, suppose another instance
K-Nearest Neighbors Algorithm in Python Read More »
1-import csv 2-fcsv=open(‘mycsv.csv’, ‘r’) 3-table=csv.reader(fcsv) 4-for row in table: 5- print(row) Program Description In the above program a library csv is imported in the first file which is used to manipulate csv files. Moreover, a file object fcsv is created using open function, thereafter file object is passed into reader function
Write a program which opens a CSV file in Python and Reads Data from it Read More »
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