Sometimes you may need to update table in SQL which you have created. For this you need to use UPDATE command with SET option. In this post, you will know that how you can update a record of SQL database. You can see in the below program that a database school is created and inside […]
Update Command in Structured Query Language (SQL) Read More »
An array in Java is a collection of values having contiguous memory locations and share a common name. Suppose you want to create an array of five numbers having data type integer and array name in num. So, first you need to declare as int num[]; Second, you need to allocate memory using new operator
Generators in Python are like ordinary function the difference that it contains yield statement instead of return. Furthermore, when a function encounters an yield statement it pauses execution of function and saves the state of the function. And when function is called again it starts from the next statement where it was paused. See the
Generators in Python Read More »
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 »