Deepeshyadav7, Author At SQA Tools

Python Set Programs, Exercises

Python set programs and exercises help beginners to get expertise in set data type, set is a collection of unique data enclosed with ‘{}’ curly braces. User can store only immutable data type to the set. e.g (int, float, string, tuple), mutable data type is not allowed as set element. e.g. (list, dictionary, set), Let’s consider if we want to store student data, with unique id, then we can use set data type to store the data.

1). Python program to create a set with some elements.

2). Python program to add an element to a set.

3). Python program to remove an element from a set.

4). Python program to find the length of a set.

5). Python program to check if an element is present in a set.

6). Python program to find the union of two sets.

7). Python program to find the intersection of two sets.

8). Python program to find the difference of two sets.

9). Python program to find the symmetric difference of two sets.

10). Python program to show if one set is a subset of another set.

11). Python program to check if two sets are disjoint.

12). Python program to convert a list to a set.

13). Python program to convert a set to a list.

14). Python program to find the maximum element in a set.

15). Python program to find the minimum element in a set.

16). Python program to find the sum of elements in a set.

17). Python program to find the average of elements in a set.

18). Python program to check if all elements in a set are even.

19). Python program to check if all elements in a set are odd.

20). Python program to check if all elements in a set are prime.

21). Python program to check if a set is a proper subset of another set.

22). Python program to find the cartesian product of two sets.

23). Python program to find the power set of a set.

24). Python program to remove all elements from a set.

25). Python program to remove a random element from a set.

26). Python program to find the difference between two sets using the “-” operator.

27). Python program to find the intersection between two sets using the “&” operator.

28). Python program to find the union of multiple sets using the | operator.

29). Python program to find the symmetric difference of two sets using the “^” operator

30). Python program to check if a set is a superset of another set.

31). Python program to find the common elements between two sets.

32). Python program to remove a specific element from a set.

33). Python program to add multiple elements to a set.

34). Python program to remove multiple elements from a set.

35). Python program to check if a set is empty.

36). Python program to check if two sets are equal.

37). Python program to check if a set is a frozen set.

38). Python program to create a frozen set.

39). Python program to find the difference between multiple sets.

40). Python program to find the intersection between multiple sets.

41). Python program to check if any element in a set is a substring of a given string.

42). Python program to check if any element in a set is a prefix of a given string.

43). Python program to check if any element in a set is a suffix of a given string.

44). Python program to find the index of an element in a set.

45). Python program to convert a set to a dictionary with each element as key and value to an empty set.

46). Python program to create a set of even numbers from 1 to 20.

47). Python program to create a set of odd numbers from 1 to 20.

48). Python program to create a set of your favorite actors.

49). Python program to create a set of your favorite movies.

50). Python program to create two sets of books and find the intersection of sets.

51). Python program to find the longest word in a set.

Sort Lines of File with Python

Sort lines of file with Python is an easy way to arrange the file content in ascending order. In this article, we will focus to sort lines of file with the length of each line and sorting the lines in Alphabetical order.

Sort lines of file with line length size:

Let’s consider a text with the name sortcontent.txt which
contains some lines that we will try to sort on the basis of length of the each line.

				
					# sortcontent.txt
This is Python
Hello Good Morning How Are You.
This is Java
Python is good language

Steps to solve the program

Open the first file using open(“sortcontent.txt”,”r”).
Read all the lines of the file using readlines() method
Now compare all lines one by one and exchange place
of long length lines with small length lines to re-arrange them
in ascending order using a nested loop.
re-write all the lines of the list in ascending order.

				
					# Open file in read mode with context manager
with open("sortcontent.txt", "r") as file:
    # Read list of lines.
    FileLines = file.readlines()
    # Initial for loop to start picking each line one by one
    for i in range(len(FileLines)):
        # Initial for loop to compare all remaining line with previous one.
        for j in range(i+1, len(FileLines)):
            # compare each line length, swap small len line with long len line.
            if len(FileLines[i]) > len(FileLines[j]):
                temp = FileLines[i]
                FileLines[i] = FileLines[j]
                FileLines[j] = temp
            else:
                continue

# re-write all the line one by one to the file
with open('ReadContent.txt', "w") as file:
    # Combine all the sequentially arrange lines with join method.
    all_lines = ''.join(FileLines)
    # overwrite all the existing lines with new one
    file.write(all_lines)

Output: Open the sortcontent.txt file to see the output. below content will be available in the file. All lines of the file will arrange in ascending as per their length.

				
					This is Java
This is Python
Python is good language
Hello Good Morning How Are You.

Sort lines of file in Alphabetical order:

Let’s consider a text file with a city name list, where names are mentioned one name in each line In the below program will sort the line of the file in alphabetical order, reads all the names from a file, and print them in alphabetical order.

				
					# cityname.txt
Kolkata
Mumbai
Pune
Bangalore
Delhi

				
					# open file with context manager
with open('cityname.txt') as file:
    # read all lines with readlines() method.
    file_lines = file.readlines()
    # sort line of file in alphabetical order
    file_lines.sort()
    # print all sorted name using loop
    for line in file_lines:
        print(line)

When we will run above program, will get following output.

				
					Bangalore
Delhi
Kolkata
Mumbai
Pune

Python file program to count the number of lines in a file.
Python file program to get all odd and even length words in two lists.
Python file program to get all mobile numbers from a file.
Python file program to compare two files.
Python file program to count the number of lines in a file.

display words from a file that has less than 5 characters.

Python Projects For Beginners

This article has common Python Projects for beginners, which have all categories of projects from basic to advanced.

Basic Level Projects:

Basic Calculator
Show Calendar
Convert pdf to text
Convert image to pdf
Convert dictionary to JSON
Convert JPEG to PNG
Convert JSON to CSV
Convert XML to JSON
Convert book into audiobook
Decimal to binary convertor and vice versa
DNS Records
Encrypt and decrypt text
Extract zip files
Fetch HTTP status code
Fetch open ports
Hashing passwords
Merge csv
Merge pdf
QR code generator
Random password generator

Intermediate Level Projects:

Capture screenshot
Calculate age
Chrome Automation
Convert numbers into words
Script to encrypt files and folders
Article Downloader
Duplicate file remover
Email GUI
Email verification
Facebook dp downloader
Get wifi password
Github repo automation
Image to speech
Language Translator
Password manager
Plagiarism checker
Python image compressor
Send an email with a python
Send mail from CSV
Set alarm
URL shortener

Advance Level Projects:

Auto birthday wisher.
Auto Backup.
Auto-fill the google form.
Automate Facebook bot.
Automatic certificate generator.
Automatic Facebook login
Calculator GUI
Calendar GUI
CLI todo
Simple Stopwatch
Dictionary GUI
Easy cartoonify the image
Video Player
Extract text from PDF
Gesture control media player
Google meeting bot
Image to sketch
Noise reduction script
Password manager GUI
PDF reader with voice
Quote scraper
Screen recorder
Speech to text
Text to speech
Text editor
Voice Translator
Video to audio converter

Python program to convert a dictionary into n sized dictionary

Python program to convert a dictionary into n sized dictionary, In this dictionary program, will break the dictionary into a specified size and store it in a list.

Steps to solve the program

1. Initiate three variables
N = 3 (size of the dictionary)
temp = {} (empty dictionary)
count = 1 (initiate counter)
output = [] (empty list to store output)2. Iterate through the dictionary data using the loop.
for val in Input_values3. Store key value in temp dictionary its size is equal to N, and
add temp to the output list, re-initiate after that count=1 . and temp={}
4. Print output.

				
					input_dict = { 'a':1, 'b':2, 'c':3, 'd':4, 'e':5, 'f':6 }
N = 3
temp = {}
count = 1
output = []
for val in input_dict:
    if count == N:
        output.append(temp)
        count = 1
        temp = {}
    else:
        temp[val] = input_dict[val]
        count+= 1
print("Output : ", output)

Output :

				
					Output :  [{'a': 1, 'b': 2}, {'d': 4, 'e': 5}]

Sort Dictionary by values summation

Python program to sort dictionary by value summation

Python program to sort dictionary by value summation, In this dictionary program will sort the dictionary data as per the sum of list data in ascending order.

Steps to solve the program

1. Create an empty dictionary temp, temp = {}
2. Iterate over the dictionary key and value with for loop.
for key, value in input_dict.items()
3. Add the key and sum of values in the temp dictionary.
temp[key] = sum(value)4. Sort all the elements of the dictionary using the sorted method.
which will return the list tuple of key and value pairs.
sorted(temp.items(), key=lambda x:x[1])
5. Convert a list of data into a dictionary.
output = dict(sorted_values)
6. print the output.

				
					input_dict = { "x":[1,5,6], "y":[4,8,2], "c":[3,9] }
temp = {}
for key, value in input_dict.items():
    temp[key] = sum(value)

sorted_values = sorted(temp.items(), key=lambda x:x[1])
output = dict(sorted_values)
print(output)

Output :

				
					 { x:12, c:12, y:14}

Invert a given dictionary with non-unique hashable values.

convert a dictionary into n sized dictionary.

Python String Programs, Exercises, Examples

Python string is a sequence of characters, such as “hello”. They can be used to represent text in a programming language. Strings can be created by enclosing a sequence of characters between double quotes, such as “hello”, or by using the str() function.

1). Write a Python program to get a string made of the first and the last 2 chars from a given string. If the string length is less than 2, return instead of the empty string

2). Python string program that takes a list of strings and returns the length of the longest string.

3). Python string program to get a string made of 4 copies of the last two characters of a specified string (length must be at least 2).

4). Python string program to reverse a string if it’s length is a multiple of 4.

5). Python string program to count occurrences of a substring in a string.

6). Python string program to test whether a passed letter is a vowel or consonant.

7). Find the longest and smallest word in the input string.

8). Print most simultaneously repeated characters in the input string.

9). Write a Python program to calculate the length of a string with loop logic.

10). Write a Python program to replace the second occurrence of any char with the special character $.
Input = “Programming”
Output = “Prog$am$in$”

11). Write a python program to get to swap the last character of a given string.
Input = “SqaTool”
Output = “IqaTooS”

12). Write a python program to exchange the first and last character of each word from the given string.
Input = “Its Online Learning”
Output = “stI enlino gearninL”

13). Write a python to count vowels from each word in the given string show as dictionary output.
Input = “We are Learning Python Codding”
output = {“We” : 1, “are” : 2, “Learning” : 3, “Python”:1, “Codding”}

14). Write a python to repeat vowels 3 times and consonants 2 times.
Input = “Sqa Tools Learning”
Ouput = “SSqqaaa TToooooollss LLeeeaaarrnniiinngg”

15). Write a python program to re-arrange the string.
Input = “Cricket Plays Virat”
Output = “Virat Plays Cricket”

16). Write a python program to get all the digits from the given string.
Input = “””
Sinak’s 1112 aim is to 1773 create a new generation of people who
understand 444 that an organization’s 5324 success or failure is
based on 555 leadership excellence and not managerial
acumen
“””
Output = [1112, 5324, 1773, 5324, 555]

17). Write a python program to replace the words “Java” with “Python” in the given string.
Input = “JAVA is the Best Programming Language in the Market”
Output = “Python is the Best Programming Language in the Market”

18). Write a Python program to get all the palindrome words from the string.
Input = “Python efe language aakaa hellolleh”
output = [“efe”, “aakaa”, “hellolleh”]

19). Write a Python program to create a string with a given list of words.
Input = [“There”, “are”, “Many”, “Programming”, “Language”]
Output = There are many programming languages.

20). Write a Python program to remove duplicate words from the string.
Input = “John jany sabi row john sabi”
output = “John jany sabi row”

21). Write a Python to remove unwanted characters from the given string.
Input = “Prog^ra*m#ming”
Output = “Programming”

Input = “Py(th)#@&on Pro$*#gram”
Output = “PythonProgram”

22). Write a Python program to find the longest capital letter word from the string.
Input = “Learning PYTHON programming is FUN”
Output = “PYTHON”

23). Write a Python program to get common words from strings.
Input String1 = “Very Good Morning, How are You”
Input String1 = “You are a Good student, keep it up”
Output = “You Good are”

24). Write a Python program to find the smallest and largest word in a given string.
Input = “Learning is a part of life and we strive”
Output = “a”, “Learning”

25). Check whether the given string is a palindrome (similar) or not.
Input= sqatoolssqatools
Output= Given string is not a palindrome

26). Write a program using python to reverse the words in a string.
Input= sqatools python
Output= slootaqs

27). Write a program to calculate the length of a string.
Input= “python”
Output = 6

28). Write a program to calculate the frequency of each character in a string.
Input = “sqatools”
Output = {‘s’:2, ‘q’:1, ‘a’: 1, ‘t’:1,‘o’:2, ‘l’:1, ‘s’:1}

29). Write a program to combine two strings into one.
Input:
A = ’abc’
B = ’def’
Output = abcdef

30). Write a program to print characters at even places in a string.
Input = ‘sqatools’
Output = saol

31). Write a program to check if a string has a number or not.
Input = ‘python1’
Output = ‘Given string have a number’

32). Write a python program to count the number of vowels in a string.
Input= ‘I am learning python’
Output= 6

33). Write a python program to count the number of consonants in a string.
Input= ‘sqltools’
Output= 6

34). Write a program to print characters at odd places in a string.
Input = ‘abcdefg’
Output = ‘bdf’

35). Write a program to remove all duplicate characters from a given string in python.
Input = ‘sqatools’
Output = ‘sqatol’

36). Write a program to check if a string has a special character or not
Input = ‘python$$#sqatools’
Output = ‘Given string has special characters

37). Write a program to exchange the first and last letters of the string
Input = We are learning python
Output = ne are learning pythoW

38). Write a program to convert all the characters in a string to Upper Case.
Input = ‘I live in pune’
Output = ‘I LIVE IN PUNE’

39). Write a program to remove a new line from a string using python.
Input = ‘objectorientedprogramming\n’
Output = ‘Objectorientedprogramming’

40). Write a python program to split and join a string
Input =‘Hello world’
Output = [‘Hello’, ‘world’]
Hello-world

41). Write a program to print floating numbers up to 3 decimal places and convert it to string.
Input = 2.14652
Output= 2.146

42). Write a program to convert numeric words to numbers.
Input = ‘five four three two one’
Output = 54321

43). Write a python program to find the location of a word in a string
Input Word = ‘problems’
Input string = ‘ I am solving problems based on strings’
Output = 4

44). Write a program to count occurrences of a word in a string.

Word = ‘food’
Input str = ‘ I want to eat fast food’
Occurrences output= 1

Word = ‘are’
Input str = “We are learning Python, wow are you”
Occurrences output = 2

45). Write a python program to find the least frequent character in a string.
Input = ‘abcdabdggfhf’
Output = ‘c’

46). Find the words greater than the given length.
Ex length = 3
Input = ‘We are learning python’
Output – ‘learning python’

47). Write a program to get the first 4 characters of a string.
Input = ‘Sqatools’
Output = ‘sqat’

48). Write a Python program to get a string made of the first 2 and the last 2 chars from a given string.
Input = ‘Sqatools’
Output = ‘Sqls’

49). Write a python program to print the mirror image of the string.
Input = ‘Python’
Output = ‘nohtyp

50). Write a python program to split strings on vowels
Input = ‘qwerty’
Output = ‘qw rty’

51). Write a python program to replace multiple words with certain words.
Input = “I’m learning python at Sqatools”
Replace python with SQA and sqatools with TOOLS
Output = “I’m learning SQA at TOOLS “

52). Write a python program to replace different characters in the string at once.
Input = ‘Sqatool python’
Replace a with 1,
Replace t with 2,
Replace o with 3
Output = ‘sq1233l py2h3n”

53). Write a python program to remove empty spaces from a list of strings.
Input = [‘Python’, ‘ ‘, ‘ ‘, ‘sqatools’]
Output = [‘Python’, ‘sqatools’]

54). Write a python program to remove punctuations from a string
Input = ‘Sqatools : is best, for python’
Output = ‘Sqatools is best for python’

55). Write a python program to find duplicate characters in a string
Input = “hello world”
Output = ‘lo’

56). Write a python program to check whether the string is a subset of another string or not
Input str1 = “iamlearningpythonatsqatools”
str = ‘pystlmi’
Output = True

57). Write a python program to sort a string
Input = ‘xyabkmp’
Output = ‘abkmpxy’

58). Write a python program to generate a random binary string of a given length.
Input = 8
Output = 10001001

59). Write a python program to check if the substring is present in the string or not
Input string= ‘I live in Pune’
Substring= ‘I live ‘
Output = ‘Yes

60). Write a program to find all substring frequencies in a string.
Input str1 = “abab”
Output = {‘a’: 2, ‘ab’: 2, ‘aba’: 1,‘abab’: 1, ‘b’: 2, ‘ba’: 1, ‘bab’: 1}

61). Write a python program to print the index of the character in a string.
Input = ‘Sqatools’
Output = ‘The index of q is 1’

62). Write a program to strip spaces from a string.
Input = ‘ sqaltoolspythonfun ‘
Output = ‘ sqaltoolspythonfun’

63). Write a program to check whether a string contains all letters of the alphabet or not.
Input = ‘abcdgjksoug’
Output = False

64). Write a python program to convert a string into a list of words.
Input = ‘learning python is fun’
Output = [learning, python, is, fun]

65). Write a python program to swap commas and dots in a string.
Input = sqa,tools.python
Output = sqa.tools,python

66). Write a python program to count and display the vowels in a string
Input = ‘welcome to Sqatools’
Output = 7

67). Write a Python program to split a string on the last occurrence of the delimiter.
Input = ‘l,e,a,r,n,I,n,g,p,y,t,h,o,n’
Output = [‘l,e,a,r,n,I,n,g,p,y,t,h,o ‘ ,’n’]

68). Write a Python program to find the first repeated word in a given string.
Input = ‘ab bc ca ab bd’
Output = ‘ab’

69). Write a program to find the second most repeated word in a given string using python.
Input = ‘ab bc ac ab bd ac nk hj ac’
Output = (‘ab’, 2)

70). Write a Python program to remove spaces from a given string.
Input = ‘python at sqatools’
Output = ‘pythonatsqatools’

71). Write a Python program to capitalize the first and last letters of each word of a given string.
Input = ‘this is my first program’
Output = ‘ThiS IS MY FirsT PrograM’

72). Write a Python program to calculate the sum of digits of a given string.
Input = ’12sqatools78′
Output = 18

73). Write a Python program to remove zeros from an IP address.
Input = 289.03.02.054
Output = 289.3.2.54

74). Write a program to find the maximum length of consecutive 0’s in a given binary string using python.
Input = 10001100000111
Output = 5

75). Write a program to remove all consecutive duplicates of a given string using python.
Input = ‘xxxxyy’
Output = ‘xy’

76). Write a program to create strings from a given string. Create a string that consists of multi-time occurring characters in the said string using python.
Input = “aabbcceffgh”
Output = ‘abcf’

77). Write a Python program to create a string from two given strings combining uncommon characters of the said strings.

Input string :
s1 = ‘abcdefg’
s2 = ‘xyzabcd’
Output string : ‘efgxyz’

78). Write a Python code to remove all characters except the given character in a string.
Input = “Sqatools python”
Remove all characters except S
Output = ‘S’

79). Write a program to count all the Uppercase, Lowercase, special character and numeric values in a given string using python.
Input = ‘@SqaTools.lin’
Output:
Special characters: 1
Uppercase characters: 2
Lowercase characters: 8

80). Write a Python program to count a number of non-empty substrings of a given string.
Input a string = ‘sqatools12’
Number of substrings = 55

81). Write a program to remove unwanted characters from a given string using python.
Input = ‘sqa****too^^{ls’
Output = ‘Sqatools’

82). Write a program to find the string similarity between two given strings using python.
Input :
Str1 = ‘Learning is fun in Sqatools’
Str2 = ‘Sqatools Online Learning Platform’

Output :
Similarity : 0.4

83). Write a program to extract numbers from a given string using python.
Input = ‘python 456 self learning 89’
Output = [456, 89]

84). Write a program to split a given multiline string into a list of lines using python.
Input =”’This string Contains
Multiple
Lines”’
Output = [‘This string Contains’, ‘Multiple’, ‘Lines’]

85). Write a program to add two strings as they are numbers using python.
Input :
a=’3′, b=’7′
Output = ’10’

86). Write a program to extract name from a given email address using python.
Input = ‘student1@gmail.com’
Output = ‘student’

87). Write a program that counts the number of leap years within the range of years using python. The range of years should be accepted as a string.

(“1981-2001) = Total leap year 5

88). Write a program to insert space before every capital letter appears in a given word using python.
Input = ‘SqaTools pyThon’
Output = ‘ Sqa Tools py Thon’

89). Write a program to uppercase half string using python.
Input = ‘banana’
Output = ‘banANA’

90). Write a program to split and join a string using “-“.
Input = ‘Sqatools is best’
Output = ‘Sqatools-is-best’

91). Write a python program to find permutations of a given string using in built function.
Input = ‘CDE’
Output = [‘CDE’, ‘CED’ ‘EDC’, ‘ECD’, ‘DCE’, ‘DEC’]

92). Write a program to avoid spaces in string and get the total length
Input = ‘sqatools is best for learning python’
Output = 31

93). Write a program to accept a string that contains only vowels
Input = ‘python’
Output- ‘not accepted’

Input = ‘aaieou’
Output = ‘accepted’

94). Write a program to remove the kth element from the string
K=2
Input = ‘sqatools’
Output = ‘sqtools’

95). Write a program to check if a given string is binary or not.
Hint: Binary numbers only contain 0 or 1.

Input = ‘01011100’
Output = yes

Input = ‘sqatools 100’
Output = ‘No’

96). Write a program to add ‘ing’ at the end of the string using python.
Input = ‘xyz’
Output = ‘xyzing’

97). Write a program to add ly at the end of the string if the given string ends with ing.
Input = ‘winning’
Output = ‘winningly’

98). Write a program to reverse words in a string using python.
Input = ‘string problems’
Output = ‘problems string’

99). Write a program to print the index of each character in a string.
Input = ‘sqatools’
Output :
Index of s is 0
Index of q is 1
Index of a is 2
Index of t is 3
Index of o is 4
Index of o is 5
Index of l is 6
Index of s is 7

100). Write a program to find the first repeated character in a string and its index.
Input = ‘sqatools’
Output = (s,0)

101). Write a program to swap cases of a given string using python.
Input = ‘Learning Python’
Output = ‘lEARNING pYTHON’

102). Write a program to remove repeated characters in a string and replace it with a single letter using python.
Input = ‘aabbccdd’
Output = ‘cabd’

103). Write a program to print a string 3 times using python.
Input = ‘sqatools’
Output = ‘sqatoolssqatoolssqatools’

104). Write a program to print each character on a new line using python.
Input = ‘python’
Output:
p
y
t
h
o
n

105). Write a program to get all the email id’s from given string using python.
Input str = “”” We have some employee whos john@gmail.com email id’s are randomly distributed jay@lic.com we want to get hari@facebook.com all the email mery@hotmail.com id’s from this given string.”””
Output = [‘john@gmail.com’, ‘ jay@lic.com’, ‘hari@facebook.com’, ‘mery@hotmail.com’ ]

106). Write a program to get a list of all the mobile numbers from the given string using python.
Input str = “”” We have 2233 some employee 8988858683 whos 3455 mobile numbers are randomly distributed 2312245566 we want 453452 to get 4532892234 all the mobile numbers 9999234355 from this given string.”””
Output = [‘8988858683’, ‘2312245566’, ‘4532892234’, ‘9999234355’]

Python OS Module Programs, Exercises

Python os module helps to perform operating system related the task like creating a directory, removing a directory, get the current directory, copying files, running the command etc.

1). Write a Python Program To Get The Current Working Directory.

2). Write a Python Program To Get The Environment Variable

3). Write a Python Program To Set The Environment Variable

4). Write a Python Program To Get a List Of All Environment Variable Using os.environ.

5). Write a Python Program To Create a Directory Using os.mkdir()

6). Write a Python Program To Create 10 DirecTories With a Random Name.

7). Write a Python Program To Create 10 DirecTories On a Nested Level.

8). Write a Python Program To Remove An Empty Directory Using os.rmdir()

9). Write a Python Program To Remove a Non-empty DirecTory Using

10). Write a Python Program To Join 2 paths.

11). Write a Python Program To Check The File On a Given Path.

12). Write a Python Program To Check The Directory On The Given Path

13). Write a Python Program To Get a list Of all data from the Target Path.

14). Write a Python Program To Get The Total File Count In The Target Path.

15). Write a Python Program To Get The Total Folder Count In The Target Path

16). Write a Python Program To Get The Count Of Each File Extension In The Target Path.

17). Write a Python Program To Copy The File Source Path To The Target Path.

18). Write a Python Program To Copy Specific Extension Files From The Source To The Target Path.

19). Write a Python Program To Copy 10 Files In 10 Different Nested Directories.

20). Write a Python Program To Remove The File From The Given Path.

21). Write a Python Program To remove Specific Extension Files From The Target Path.

22). Write a Python Program To Create a Backup Application.
Note: We have To filter each extension file and copy it To a specific folder.

23). Write a Python Program To Run The Windows Commands.

24). Write a Python Program To Provide Command Line Arguments.

25). Write a Python Program To Get System Version Information.

26). Write a Python Program To List Path Set Using os.get_exce_path() Method.

27). Write a Python Program To Get a Random String Using os.urandom() Method.

28). Write a Python Program To Check Read Permission On Give Path Using os.access() Method.

29). Write a python Program To Get The File Size Using os.path.getsize() Method.

30). Write a Python Program To Change The Current Working Directory.

31). Write a Python Program To Scan Target DirecTory And Print All Files Name.
Using an os.scandir() Method.

32). Write a Python Program To Create Complete Path Directories With os.mkdirs() Method.

33). Write a Python Program To Execute Any Other Python Script Using os.sysetem() Method.

34). Write a Python Program To Create a Fake Data File Of 10 Different Extensions.

35). Write a Python Program To Print Data Name, PATH, and Data Type From Target Path.
Example 1:
Name : TestFolder
Path : C:\TestFolder
Type : Folder

Example 2:
Name : testdata.txt
Path : C:\testdata.txt
Type : File

36). Write a Python Program To Print All Nested Level Files/Folders Using os.walk() Methd

37). Write a Python Program To Change File/Folder Permission Using os.chmod() Method.

38). Write a Python Program To Change File/Folder Ownership Using os.chown() Method.

39). Write a Python Program To Rename Folder Name Using os.rename() Method.

40). Write a Python Program To Rename All Folders in Path Using os.remanes() Method.

41). Write a Python Program To Change Root Directory Using os.chroot() Method.

42). Write a Python Program To CPU Count Using os.cpu_count() Method.

43). Write a Python Program To Split Files/Folders from Path Using os.path.split() Method.

44). Write a Python Program To Get Ctime of File/Folder Using os.path.getctime() Method.

45). Write a Python Program To Get The Modified Time of File/Folder Using os.path.getmtime() Method.

46). Write a Python Program To Check Given Path Exist Using os.path.exists() Method.

47). Write a Python Program To Check Given Path is Link Using os.path.islink() Method.

48). Write a Python Program To Check All States of The File Using os.stat() Method.

51). Write a Python To Provide Command Line Arguments To Python File.

52). Write a Python Program To Get Platform Information.

53). Write a Python Program To Get Python Version Info.

2. Problem to add elements from list1 to list2.

There are two ways to add elements from list1 to list2, fone is concatenation with the plus operator and the second one is to add elements with extend method with the help of the below-given steps.

Method 1 : Using concatenation

Add elements:

Steps to solve the program

Take two lists as inputs.
Add them using the ” + ” operator.
Print the final list.

				
					#Input lists
list1 = [3, 6, 7, 81, 2]
list2 = [11, 15, 17, 13]

#Adding lists
output = list1 + list2

#Printing output
print(output)

Output :

				
					[3, 6, 7, 81, 2, 11, 15, 17, 13]

Method 2 : Using extend()

Steps to solve the program

Take two lists as input.
Combine both lists using extend().
Print the combined list.

				
					#Input lists
list1 = [3, 6, 7, 81, 2]
list2 = [11, 15, 17, 13]

#Extend method
list1.extend(list2)

#Printing output
print(list1)

Output :

				
					[3, 6, 7, 81, 2, 11, 15, 17, 13]

Python program to calculate the sum of all elements from a list.

Python program to find a product of all elements from a given list.

Python program to find the minimum and maximum elements from the list.

Python program to differentiate even and odd elements from the given list.

Python program to remove all duplicate elements from the list.

Python program to print a combination of 2 elements from the list whose sum is 10.

Square of each number

Sum of all list elements.

1. Problem to get the square of all numbers In the python list

In this program, we will take a user input as a list and print the square of all numbers In the Python list with the help of the below-given steps.

Method 1: Using for loop.

Square of all numbers in list:

Steps to solve the program

Take a list as input.
Using for loop and **n print the square of each element from the list.

				
					list1 = [3, 5, 7, 1, 8]

for val in list1:
    print(val, ":", val**2)

Output :

Method 2 : Using while loop.

Square of all numbers in list:

Steps to solve the program

Take a list as input.
Using while loop and necessary condition print the square of each element from the list.

				
					#input list 
list1 =[3,5,7,1,8]

#Creating count variable
count = 0

while count < len(list1):
    print(list1[count],":",list1[count]**2)
    count += 1

Output :

Python program to combine two lists.

Python program to calculate the sum of all elements from a list.

Python program to find a product of all elements from a given list.

Python program to find the minimum and maximum elements from the list.

Python program to differentiate even and odd elements from the given list.

Python program to remove all duplicate elements from the list.

Add elements from list1 to list2

Python Pandas Programs, Exercises

Python Pandas Programs helps to filter and sort the tabular data and gain expertise on it, Pandas is an open-source library for data analysis in Python. Pandas is one of the most popular and fastest-growing libraries in the Python ecosystem.

1). Python Pandas program to create and display a one-dimensional array-like object containing an array of data.
Output:
15
43
88
23

2). Python Pandas program to convert a series to a list and print its type.

3). Python Pandas program to add two series.
Input:
A=[1,6,9,5]
B=[5,2,4,5]
Output:
[6,8,13,10]

4). Python Pandas program to subtract two series.
Input:
A=[1,6,9,5]
B=[5,2,4,5]
Output:
[-4,4,5,0]

5). Python Pandas program to multiply two series.
Input:
A=[1,6,9,5]
B=[5,2,4,5]
Output:
[5,12,36,25]

6). Python Pandas program to divide two series.
Input:
A=[1,6,9,5]
B=[5,2,4,5]
Output:
[0.2,3,2.5,1]

7). Python Pandas program to check whether elements in the series are equal or not.
Input:
A=[1,6,9,5]
B=[5,2,4,5]
Output:
False
False
False
True

8). Python Pandas program to check whether elements in the series are greater than other series.
Input:
A=[1,6,9,5]
B=[5,2,4,5]
Output:
False
True
True
False

9). Python Pandas program to convert a dictionary to a series.
Input:
A={name: Virat, sport: cricket, age: 32}
Output:
Name Virat
Sport Cricket
Age 32

10). Python Pandas program to convert a NumPy array to a Pandas series.
Input:
[5,3,8,9,0]
Output:
0 5
1 3
2 8
3 9
4 0

11). Python Pandas program to change the data type of given a column or a Series.
Input:
0 54
1 27.90
2 sqa
3 33.33
4 tools
dtype: object
Output:
0 54.00
1 27.90
2 NaN
3 33.33
4 NaN
dtype:float64

12). Python Pandas program to convert a given Series to an array.
Input:
0 54
1 27.90
2 sqa
3 33.33
4 tools
dtype: object
Output:
[’54’, ‘27.90’,’sqa’,’33.33′, ‘tools’]

13). Python Pandas program to convert a series of lists into one series.
Input:
[Sqa, tool]
[Learning, python]
[Is, fun]
Output:
0 [Sqa, tool]
1 [Learning, python]
2 [Is, fun]
dtype: object

14). Python Pandas program to sort a given Series.
Input:
0 55
1 23
2 10
3 87
Output:
0 10
1 23
2 55
3 87

15). Python Pandas program to add some data to an existing series.
Input:
0 54
1 27.90
2 sqa
3 33.33
4 tools
Output:
0 54
1 27.90
2 sqa
3 33.33
4 tools
5 python
6 100

16). Python Pandas program to create a subset of a given series based on value and condition.
Input:
0 10
1 25
2 69
3 74
4 33
5 54
6 21
Output:
Subset of the above Data Series:
0 10
1 25
4 33
6 21

17). Python Pandas program to change the order of the index of a given series.
Input:
0 Sqa
1 tools
2 Learning
3 python
4 Is
5 fun
Output:
2 Learning
3 python
0 Sqa
1 tools
4 Is
5 fun

18). Python Pandas program to find the mean of the data of a given series.
Input:
0 5
1 4
2 8
3 6
Output:
5.75

19). Python Pandas program to find the standard deviation of the given Series.
Input:
0 2
1 4
2 6
3 8
4 10
Output: = 3.162277

20). Python Pandas program to get the items of a series not present in another series.
Input:
A=
0 4
1 7
2 3
B=
0 9
1 4
2 3
Output:
Items of A that are not present in B
1 7

21). Python Pandas program to calculate the maximum value from a series.
Input:
0 54
1 38
2 67
3 87
Output:
87

22). Python Pandas program to calculate the minimum value from a series.
Input:
0 54
1 38
2 67
3 87
Output:
38

23). Python Pandas program to calculate the frequency of each value of a series.
Input:
0 3
1 0
2 3
3 2
4 2
5 0
6 3
7 3
8 2
Output:
0 2
2 3
3 4

24). Python Pandas program to extract items at given positions of a series.
Input:
0 3
1 0
2 3
3 2
4 2
5 0
6 3
7 3
8 2
Output:
1 0
4 2
7 3

25). Python Pandas program to convert the first and last character of each word to upper case in each word of a given series.
Input:
0 sqatools
1 python
2 data
3 science
Output:
0 SqatoolS
1 PythoN
2 DatA
3 SciencE

26). Python Pandas program to calculate the number of characters in each word in a series.
Input:
0 Virat
1 Rohit
2 Pant
3 Shikhar
Output:
0 6
1 6
2 4
3 7

27). Python Pandas program to convert a series of date strings to a time-series.
Input:
0 2 Feb 2020
1 5/11/2021
2 7-8-2022
Output:
0 2020-02-02 00:00:00
1 2021-11-05 00:00:00
2 2022-08-07 00:00:00

28). Python Pandas program to filter words from a given series that contain at least one vowel.
Input:
0 sqatools
1 SQL
2 python
3 white
4 bsc
Output:
0 sqatools
2 python
3 white

29). Python Pandas program to find the index of the first occurrence of the smallest and largest value of a series.
Input:
0 54
1 25
2 38
3 87
Output:
1
3

30). Python Pandas program to convert a dictionary into DataFrame.

31). Python Pandas program to print the first n rows of a Dataframe.

32). Python Pandas program to print the last n rows of a DataFrame.

33). Python pandas program to print the selected columns from DataFrame.
Input:
Sr.no. name age
1 Alex 30
2 John 27
3 Peter 29
Output:
name age
Alex 30
John 27
Peter 29

34). Python Pandas program to print the selected rows from DataFrame.
Input:
Sr.no. name age
1. Alex 30
2. John 27
3. Peter 29
Output:
Sr.no. name age
2. John 27

35). Python Pandas program to select the rows where the age is greater than 29.
Input:
Sr.no. name age
1. Alex. 30
2. John. 27
3. Peter. 29
4. Klaus. 33
Output:
Sr.no. name age
1. Alex. 30
4. Klaus. 33

36). Python Pandas program to count the number of rows and columns in a DataFrame.
Input:
Sr.no. name age
1. Alex. 30
2. John. 27
3. Peter. 29
4. Klaus. 33
Output:
No of rows:4
No of columns:3

37). Python Pandas program to select the rows where age is missing.
Input:
Sr.no. name age
1. Alex. 30
2. John. np.nan
3. Peter. 29
4. Klaus. np.nan
Output:
Sr.no. name age
2. John. np.nan
4. Klaus. np.nan

38). Python Pandas program to print the names who’s age is between 25-30 using Pandas.
Input:
Sr.no. name age
1. Alex. 30
2. John. 27
3. Peter. 29
4. Klaus. 33
Output:
Sr.no. name age
2. John. 27
3. Peter. 29

39). Python Pandas program to change the age of John to 24.
Input:
Sr.no. name age
1. Alex. 30
2. John. 27
3. Peter. 29
4. Klaus. 33
Output:
Sr.no. name age
1. Alex. 30
2. John. 24
3. Peter. 29
4. Klaus. 33

40). Python Pandas program to calculate the sum of age column.
Input:
Sr.no. name age
1. Alex. 30
2. John. 27
3. Peter. 29
4. Klaus. 33
Output:
119

41). Python Pandas program to add a new row in the DataFrame.
Input:
Sr.no. name age
1. Alex. 30
2. John. 27
3. Peter. 29
4. Klaus. 33
Output:
Sr.no. name age
1. Alex. 30
2. John. 27
3. Peter. 29
4. Klaus. 33
5. Jason. 28

42). Python Pandas program to sort the DataFrame first by ‘name’ in ascending order.
Input:
Sr.no. name age
1. Alex. 30
2. John. 27
3. Peter. 29
4. Klaus. 33
Output:
Sr.no. name age
1. Alex. 30
2. John. 27
4. Klaus. 33
3. Peter. 29

43). Python Pandas program to calculate the mean of age column.
Input:
Sr.no. name age
1. Alex. 30
2. John. 27
3. Peter. 29
4. Klaus. 33
Output:
29.75

44). Python Pandas program to sort the DataFrame by ‘age’ column in ascending order.
Input:
Sr.no. name age
1. Alex. 30
2. John. 27
3. Peter. 29
4. Klaus. 33
Output:
Sr.no. name age
2. John. 27
3. Peter. 29
1. Alex. 30
4. Klaus. 33

45). Python Pandas program to replace John with Jim.
Input:
Sr.no. name age
1. Alex. 30
2. John. 27
3. Peter. 29
4. Klaus. 33
Output:
Sr.no. name age
1. Alex. 30
2. Jim. 27
3. Peter. 29
4. Klaus. 33

46). Python Pandas program to delete records for John.
Input:
Sr.no. name age
1. Alex. 30
2. John. 27
3. Peter. 29
4. Klaus. 33
Output:
Sr.no. name age
1. Alex. 30
3. Peter. 29
4. Klaus. 33

47). Python Pandas program to add a new column in a DataFrame.
Input:
Sr.no. name age
1. Alex. 30
2. John. 27
3. Peter. 29
4. Klaus. 33
Output:
Sr.no. name age. Salary
1. Alex. 30. 50000
2. John. 27. 65000
3. Peter. 29. 58000
4. Klaus. 33. 66000

48). Python Pandas program to iterate over rows in a DataFrame.
Input:
A=[{name:Yash, percentage:78},{name:Rakesh, percentage: 80},{
name: Suresh, percentage:60}]
Output:
Yash 78
Rakesh 80
Suresh 60

49). Python Pandas program to get a list of column headers from the DataFrame.
Input:
A={name:[Virat,Messi, Kobe], sport:[cricket, football, basketball]}
Output:
[name, sport]

50). Python Pandas program to rename columns of a given DataFrame.
Input:
C1. C2. C3
1. 6. 8
3. 8. 2
9. 0. 6
Output:
A. B. C
1. 6. 8
3. 8. 2
9. 0. 6

51). Python Pandas program to change the order of columns in a DataFrame.
Input:
Sr.no. name age. Salary
1. Alex. 30. 50000
2. John. 27. 65000
3. Peter. 29. 58000
4. Klaus. 33. 66000
Output:
Sr.no. name Salary Age
1. Alex. 50000. 30
2. John. 65000 27
3. Peter. 58000. 29
4. Klaus. 66000 33

52). Python Pandas program to write a DataFrame to a CSV file using a tab separator.
Input:
Sr.no. name age. Salary
1. Alex. 30. 50000
2. John. 27. 65000
3. Peter. 29. 58000
4. Klaus. 33. 66000
Output:
Sr.no\tname\tage\tSalary
1\tAlex\t30\t50000
2\tJohn\t27\t65000
3\tPeter\t29\t58000
4\tKlaus\t33\t66000

53). Python Pandas program to count Country wise population from a given data set (columns of a data set- Country, population).
Output:
Country. Population
China. 57289229
India. 49262728
.
.
.

54). Python Pandas program to replace all the NaN values with a scaler in a column of a Dataframe.
Input:
Sr.no. name age
1. Alex. 30
2. John. np.nan
3. Peter. 29
4. Klaus. np.nan
Output:
Sr.no. name age
1. Alex. 30
2. John. 25
3. Peter. 29
4. Klaus. 25

55). Python Pandas program to count the NaN values in a Dataframe.
Input:
Sr.no. name age
1. Alex. 30
2. John. np.nan
3. Peter. 29
4. Klaus. np.nan
Output:
2

56). Python Pandas program to shuffle rows in a DataFrame.
Input:
Sr.no. name age. Salary
1. Alex. 30. 50000
2. John. 27. 65000
3. Peter. 29. 63000
4. Klaus. 33. 59000
Output:
Sr.no. name age. Salary
2. John. 27. 65000
4. Klaus. 33. 59000
1. Alex. 30. 50000
3. Peter. 29. 63000

57). Python Pandas program to rename a column in a DataFrame.
Input:
Rank. name age. Salary
1. Alex. 30. 50000
2. John. 27. 65000
3. Peter. 29. 63000
4. Klaus. 33. 59000
Output:
Sr.no. name age. Salary
1. Alex. 30. 50000
2. John. 27. 65000
3. Peter. 29. 63000
4. Klaus. 33. 59000

58). Python Pandas program to get a list of records in a column of a DataFrame.
Input:
Sr.no. name age. Salary
1. Alex. 30. 50000
2. John. 27. 65000
3. Peter. 29. 63000
4. Klaus. 33. 59000
Output:
[Alex, John, Peter, Klaus]

59). Python Pandas program to find the row where the value of a column is maximum.
Input:
Sr.no. name age. Salary
1. Alex. 30. 50000
2. John. 27. 65000
3. Peter. 29. 63000
4. Klaus. 33. 59000
Output: Row where salary is maximum 2

60). Python Pandas program to find the row where the value of a given column is minimum.
Input:
Sr.no. name age. Salary
1. Alex. 30. 50000
2. John. 27. 65000
3. Peter. 29. 63000
4. Klaus. 33. 59000
Output= Row where salary is minimum 1

61). Python Pandas program to check whether a column is present in a DataFrame.
Input:
Sr.no. name age. Salary
1. Alex. 30. 50000
2. John. 27. 65000
3. Peter. 29. 63000
4. Klaus. 33. 59000
Output:
The company column is not present in DataFrame
The name column is present in DataFrame

62). Python Pandas program to get the datatypes of columns of a DataFrame.
Input:
Sr.no. name age. Salary
1. Alex. 30. 50000
2. John. 27. 65000
3. Peter. 29. 63000
4. Klaus. 33. 59000
Output:
Sr.no. Int64
Name. Object
Age. Int64
Salary. Int64

63). Python Pandas program to convert a list of lists into a Dataframe.
Input:
[[Virat, cricket],[Messi, football]]
Output:
0 column1 column2
1. Virat. Cricket
2. Messi. Football

64). Python Pandas program to find the index of a column from the DataFrame.
Input:
Sr.no. name age. Salary
1. Alex. 30. 50000
2. John. 27. 65000
3. Peter. 29. 63000
4. Klaus. 33. 59000
Output: Index number of age is 2

65). Python Pandas program to select all columns except one column in a DataFrame.
Input:
Sr.no. name age. Salary
1. Alex. 30. 50000
2. John. 27. 65000
3. Peter. 29. 63000
4. Klaus. 33. 59000
Output:
Sr.no. name Salary
1. Alex. 50000
2. John. 65000
3. Peter. 63000
4. Klaus. 59000

66). Python Pandas program to remove the first n rows of a DataFrame.
Input:
Sr.no. name age. Salary
1. Alex. 30. 50000
2. John. 27. 65000
3. Peter. 29. 63000
4. Klaus. 33. 59000
Output:
After removing the first 2 rows
Sr.no. name age. Salary
3. Peter. 29. 63000
4. Klaus. 33. 59000

67). Python Pandas program to remove the last n rows of a given DataFrame.
Input:
Sr.no. name age. Salary
1. Alex. 30. 50000
2. John. 27. 65000
3. Peter. 29. 63000
4. Klaus. 33. 59000
Output:
After removing the last 2 rows
Sr.no. name age. Salary
1. Alex. 30. 50000
2. John. 27. 65000

68). Python Pandas program to reverse the order of rows of a given DataFrame.
Input:
Sr.no. name age. Salary
1. Alex. 30. 50000
2. John. 27. 65000
3. Peter. 29. 63000
4. Klaus. 33. 59000
Output:
Sr.no. name age. Salary
4. Klaus. 33. 59000
3. Peter. 29. 63000
2. John. 27. 65000
1. Alex. 30. 50000.

69). Python Pandas program to reverse the order of columns in a DataFrame.
Input:
Sr.no. name age. Salary
1. Alex. 30. 50000
2. John. 27. 65000
3. Peter. 29. 63000
4. Klaus. 33. 59000
Output:
Salary. age. Name. Sr.no.
50000. 30. Alex. 1
65000. 27. John. 2
63000. 29. Peter. 3
59000. 33. Klaus. 4

70). Python Pandas program to select columns by the object datatype from the DataFrame.
Input:
Sr.no. name age. Salary
1. Alex. 30. 50000
2. John. 27. 65000
3. Peter. 29. 63000
4. Klaus. 33. 59000
Output:
Select string columns
Name
Alex
John
Peter
Klaus

71). Python Pandas program to convert continuous values of a column of a DataFrame to categorical.
Input:
{Student_id:[1,2,3,4], marks:[30,50,70,80]}
Output:
0. Marks
1. Fail
2. 2nd class
3. 1st class
4. 1st class with distinction

72). Python Pandas program to convert all the string values in the DataFrame to uppercases.
Input:
0. cricket
1. Yes
2. pass
3. FAIL
Output:
0. Cricket
1. Yes
2. Pass
3. Fail

73). Python Pandas program to check whether only the upper case is present in a column of a DataFrame.
Input:
0. Name
1. Kate
2. Jason
3. ROBERT
4. MARK
5. Dwyane
Output:
0. Name. Name
1. Kate. False
2. Jason. False
3. ROBERT True
4. MARK. True
5. Dwyane. False

74). Python Pandas program to check whether only the lower case is present in a given column of a DataFrame .
Input:
0. Name
1. kate
2. jason
3. ROBERT
4. MARK
5. dwyane
Output:
0. Name. Name
1. Kate. True
2. Jason. True
3. ROBERT False
4. MARK. False
5. dwyane. True

75). Python Pandas program to check whether only numeric values are present in a column of a DataFrame.

Input:
0. Marks
1. Pass
2. 88
3. 2nd class
4. 90
5. Distinction
Output:
0. Marks. Marks
1. Pass. False
2. 88. True
3. 2nd class. False
4. 90. True
5. Distinction. False

76). Python Pandas program to check whether only alphabetic values present in a column of a DataFrame.
Input:
0. Marks
1. Pass
2. 88
3. First class
4. 90
5. Distinction
Output:
0. Marks. Marks
1. Pass. True
2. 88. False
3. First class. False
4. 90. False
5. Distinction. True

77). Python Pandas program to get the length of the integer of a column in a DataFrame.
Input:
0. Sales
1. 55000
2. 75000
3. 330000
4. 10000
Output:
0. Sales. Sales_length
1. 55000. 5
2. 75000. 5
3. 330000. 6
4. 1000. 4

78). Python Pandas program to extract email from a specified column of a given DataFrame.
Input:
0. Company_mail
1. TCS. tcs@yahoo.com
2. Apple. apple@icloud.com
3 Google. google@gmail.com
Output:
0. Company_mail email
1. TCS. tcs@yahoo.com tcs@yahoo.com
2. Apple. apple@icloud.com apple@icloud.com
3 Google.google@gmail.com google@gmail.com

79). Python Pandas program to extract the hash attached word from Twitter text from the specified column of a given DataFrame.
Input:
0. Tweets
1. Pune #love
2. #boycottmovie
3. enjoying #peace
Output:
0. Tweets extracted_word
1. Pune #love. love
2. #boycottmovie. boycottmovie
3. enjoying #peace peace

80). Python Pandas program to extract only words from a column of a DataFrame.
Input:
Name Address
Ramesh. 297 shukrawar peth
Suresh. 200 ravivar peth
Sanket. 090 shanivar peth
Output:
Name Address Only_words
Ramesh. 297 shukrawar peth shukrawar peth
Suresh. 200 ravivar peth ravivar peth
Sanket. 090 shanivar peth shanivar peth

81). Python Pandas program to join the two Dataframes along rows.
Input:
D1
Id Name. Age
1. Yash. 30
2. Gaurav. 27
3. Sanket. 28
D2
Id. Name. Age
4. Atharva. 26
3. Tanmay. 22
Output:
Id Name. Age
1. Yash. 30
2. Gaurav. 27
3. Sanket. 28
4. Atharva. 26
3. Tanmay. 22

82). Python Pandas program to join the two Dataframes along columns.
Input:
D1
Id Name. Age
1. Yash. 30
2. Gaurav. 27
3. Sanket. 28
D2
Id. Name. Age
4. Atharva. 26
3. Tanmay. 22
Output:
Id Name. Age Id. Name. Age
1. Yash. 30. 4. Atharva. 26
2. Gaurav. 27. 3. Tanmay. 22
3. Sanket. 28

83). Python Pandas program to join the two Dataframes using the common column of both Dataframes.
Input:
D1
Id. Name marks1
S1. Ketan. 90
S2. Yash. 87
S3. Abhishek 77
D2
Id. Name. Marks2
S2. Yash. 70
S4. Gaurav. 65
Output:
Id. Name. Marks1. name. Marks2
S2. Yash. 87. Yash. 70

84). Python Pandas program to merge two Dataframes with different columns.

85). Python Pandas program to detect missing values from a DataFrame.
Input:
Sr.no. name age
1. Alex. 30
2. John. np.nan
3. Peter. 29
4. Klaus. np.nan
Output:
Sr.no. name age
False False. False
False False True
False False False
False False True

86). Python Pandas program to identify the columns from the DataFrame which have at least one missing value.
Input:
Sr.no. name age
1. Alex. 30
2. np.nan. np.nan
3. Peter. 29
4. Klaus. np.nan
Output:
Sr.no. False
Name. True
Age. True

87). Python Pandas program to count the number of missing values in each column of a DataFrame.
Input:
Sr.no. name age
1. Alex. 30
2. np.nan. np.nan
3. Peter. 29
4. Klaus. np.nan
Output:
Sr.no. 0
Name. 1
Age. 2

88). Python Pandas program to drop the rows where at least one element is missing in a DataFrame.
Input:
Sr.no. name age
1. Alex. 30
2. np.nan. np.nan
3. Peter. 29
4. Klaus. np.nan
Output:
Sr.no. name age
1. Alex. 30
3. Peter. 29

89). Python Pandas program to drop the columns where at least one element is missing in a DataFrame.
Input:
Sr.no. name age
1. Alex. 30
2. np.nan. np.nan
3. Peter. 29
4. Klaus. np.nan
Output:
Sr.no.
1
2
3
4

90). Python Pandas program to drop the rows where all elements are missing in a DataFrame.
Input:
Sr.no. name age
1. Alex. 30
np.nan np.nan. np.nan
3. Peter. 29
4 Klaus. np.nan
Output:
Sr.no. name age
1. Alex. 30
3. Peter. 29
4. Klaus. np.nan

91). Python Pandas program to replace NaNs with the value from the previous row in a DataFrame.
Input:
Sr.no. name age
1. Alex. 30
2. np.nan. np.nan
3. Peter. 29
4. Klaus. 22
Output:
Sr.no. name age
1. Alex. 30
2. Alex. 30
3. Peter. 29
4. Klaus. 22

92). Python Pandas program to replace NaNs with the value from the next row in a DataFrame.
Input:
Sr.no. name age
1. Alex. 30
2. np.nan. np.nan
3. Peter. 29
4. Klaus. 22
Output:
Sr.no. name age
1. Alex. 30
2. Peter. 29
3. Peter. 29
4. Klaus. 22

93). Python Pandas program to replace NaNs with mean in a DataFrame.
Input:
Sr.no. name age
1. Alex. 30
2. np.nan. np.nan
3. Peter. 29
4. Klaus. 22
Output:
Sr.no. name age
1. Alex. 30
2. np.nan. 27
3. Peter. 29
4. Klaus. 22

94). Python Pandas program to replace the missing values with the most frequent values present in each column of a given DataFrame.
Input:
Sr.no. name age
1. Alex. 30
2. np.nan. np.nan
3. Peter. 29
4. Klaus. 22
5. Stefen. 22
Output:
Sr.no. name age
1. Alex. 30
2. np.nan. 22
3. Peter. 29
4. Klaus. 22
5. Stefen. 22

95). Python Pandas program to replace NaNs with the median value in a DataFrame.
Input:
Sr.no. name age
1. Alex. 30
2. np.nan. np.nan
3. Peter. 29
4. Klaus. 22
Output:
Sr.no. name age
1. Alex. 30
2. John. 29
3. Peter. 29
4. Klaus. 22

96). Python Pandas program to import a CSV file.

97). Python Pandas program to import an xlsx file.

Python Set Programs, Exercises

Sort Lines of File with Python

Sort lines of file with line length size:

Let’s consider a text with the name sortcontent.txt which
contains some lines that we will try to sort on the basis of length of the each line.

Steps to solve the program

Sort lines of file in Alphabetical order:

Related Articles

Python Projects For Beginners

Basic Level Projects:

Intermediate Level Projects:

Advance Level Projects:

Python program to convert a dictionary into n sized dictionary

Steps to solve the program

Python program to sort dictionary by value summation

Steps to solve the program

Python String Programs, Exercises, Examples

Python OS Module Programs, Exercises

2. Problem to add elements from list1 to list2.

Table of Contents

Method 1 : Using concatenation

Add elements:

Steps to solve the program

Method 2 : Using extend()

Steps to solve the program

Related Articles

1. Problem to get the square of all numbers In the python list

Table of Contents

Method 1: Using for loop.

Square of all numbers in list:

Steps to solve the program

Method 2 : Using while loop.

Square of all numbers in list:

Steps to solve the program

Related Articles

Add elements from list1 to list2

Python Pandas Programs, Exercises

Sort lines of file with line length size:

Let’s consider a text with the name sortcontent.txt whichcontains some lines that we will try to sort on the basis of length of the each line.

Steps to solve the program

Sort lines of file in Alphabetical order:

Related Articles

Basic Level Projects:

Intermediate Level Projects:

Advance Level Projects:

Steps to solve the program

Steps to solve the program

Table of Contents

Method 1 : Using concatenation

Add elements:

Steps to solve the program

Method 2 : Using extend()

Steps to solve the program

Related Articles

Table of Contents

Method 1: Using for loop.

Square of all numbers in list:

Steps to solve the program

Method 2 : Using while loop.

Square of all numbers in list:

Steps to solve the program

Related Articles

Add elements from list1 to list2

Let’s consider a text with the name sortcontent.txt which
contains some lines that we will try to sort on the basis of length of the each line.