Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
Articles on Trending Technologies
Technical articles with clear explanations and examples
Write a program in Python to covert the datatype of a particular column in a dataframe
Assume, you have a dataframe, the result for converting float to int as, Before conversion Name object Age int64 Maths int64 Science int64 English int64 Result float64 dtype: object After conversion Name object Age int64 Maths int64 Science int64 English int64 Result int64 dtype: objectTo solve this, we will follow the steps given below −SolutionDefine a dataframeConvert float datatype column ‘Result’ into ‘int’ as follows −df.Result.astype(int)ExampleLet’s see the below implementation to get a better understanding −import pandas as pd data = {'Name': ['David', 'Adam', ...
Read MoreWrite a Python code to swap last two rows in a given dataframe
Assume you have dataframe and the result for swapping last two rows, Before swapping Name Age Maths Science English 0 David 13 98 75 79 1 Adam 12 59 96 45 2 Bob 12 66 55 70 3 Alex 13 95 49 60 4 Serina 12 70 78 80 After swapping Name Age Maths Science English 0 David 13 98 75 79 1 Adam 12 59 ...
Read MoreWrite a program in Python to remove one or more than one columns in a given DataFrame
Assume, you have a dataframe, one two three 0 1 2 3 1 4 5 6And the result for removing single column is, two three 0 2 3 1 5 6The result for removing after more than one column is, three 0 3 1 6To solve this, we will follow the steps given below −Solution 1Define a dataframeDelete a particular column using below method, del df['one']ExampleLet’s see the below code to get a better understanding −import pandas as pd data = [[1, 2, 3], [4, 5, 6]] df = pd.DataFrame(data, columns=('one', 'two', 'three')) print("Before ...
Read MoreWrite a program in Python to find the most repeated element in a series
Assume, you have the following series, Series is: 0 1 1 22 2 3 3 4 4 22 5 5 6 22And the result for the most repeated element is, Repeated element is: 22SolutionTo solve this, we will follow the below approach, Define a seriesSet initial count is 0 and max_count value as series first element value data[0]count = 0 max_count = data[0]Create for loop to access series data and set frequency_count as l.count(i)for i in data: frequency_count = l.count(i)Set if condition to compare with max_count value, if the condition is true ...
Read MoreWrite a program in Python to select any random odd index rows in a given DataFrame
Assume, you have a dataframe, DataFrame is: id mark age 0 1 70 12 1 2 60 13 2 3 40 12 3 4 50 13 4 5 80 12 5 6 90 13 6 7 60 12And, the result for selecting any random odd index row is, Random odd index row is: id 4 mark 50 age 13SolutionTo solve this, we will follow the steps given below −Define a dataframeCreate an empty list to append odd index valuesCreate a for loop to access all the index. It is defined ...
Read MoreWrite a program in Python to merge two dataframes based on matching data in a column
Assume, you have two dataframe, first dataframe is id country 0 1 India 1 2 UK 2 3 US 3 4 China second dataframe is id City 0 1 Chennai 1 11 Cambridge 2 22 Chicago 3 4 ChengduAnd the result for merging based on same column is, Merging data based on same column - id id country City 0 1 India Chennai 1 4 China ChengduSolutionTo solve this, we will follow the steps given below −Define a two dataframesMerge two dataframes based on the same column id is defined below, pd.merge(first_df, ...
Read MoreWrite a Python program to generate random ten rows, two columns of vowels. If both the rows are matched with same vowels, then print the index and count of matched columns
Assume, you have a dataframe, col1 col2 0 o e 1 e e 2 i u 3 e o 4 i i 5 u o 6 e a 7 u o 8 a u 9 e aThe result for matched index and count is, index is col1 col2 1 e e 4 i i count is 2SolutionTo solve this, we will follow the steps given below −Define a dataframeCompare first and second matching index values using the below method, df.iloc[np.where(df.col1==df.col2)])Find the total count of matched columns using the ...
Read MoreWrite a program in Python to modify the diagonal of a given DataFrame by 1
Assume, you have a dataframe0 1 20 10 20 30 1 40 50 60 2 70 80 90The result for replaced 1 by diagonal of a dataframe is −0 1 2 0 1 20 30 1 40 1 60 2 70 80 1SolutionTo solve this, we will follow the steps given below −Define a dataframeCreate nested for loop to access all rows and columns, for i in range(len(df)): for j in range(len(df)):Check if the condition to match the diagonals, if it is matched then replace the position by 1. It is defined below, if i == j: df.iloc[i ...
Read MoreWrite a program in Python to find the lowest value in a given DataFrame and store the lowest value in a new row and column
Assume you have a dataframe, one two three 0 12 13 5 1 10 6 4 2 16 18 20 3 11 15 58The result for storing the minimum value in new row and column is −Add new column to store min value one two three min_value 0 12 13 5 5 1 10 6 4 4 2 16 18 20 16 3 11 15 58 11 Add new row to store min value one two three min_value 0 ...
Read MoreWrite a program in Python to read sample data from an SQL Database
Assume you have a sqlite3 database with student records and the result for reading all the data is, Id Name 0 1 stud1 1 2 stud2 2 3 stud3 3 4 stud4 4 5 stud5SolutionTo solve this, we will follow the steps given below −Define a new connection. It is shown below, con = sqlite3.connect("db.sqlite3")Read sql data from the database using below function, pd.read_sql_query()Select all student data from table using read_sql_query with connection, pd.read_sql_query("SELECT * FROM student", con)ExampleLet us see the complete implementation to get a better understanding −import pandas as pd import sqlite3 con = sqlite3.connect("db.sqlite3") df = ...
Read More