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
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 »