Operations On Dataframe in Python

Checking data types of each Column in a Data Frame.

• If you want to check the data type of each column, because whenever you have been given a data, you want to really check what is the structure of the data; that means, which variable has which data type?

• In, that case you can use dtypes, because that returns a series with the data type of each column and the syntax would be you use dtypes along with the Data Frame name.

• So, Data Frame.dtypes will give you a series with the data type of each column

Here is the syntax.

Syntax = DataFrame.dtypes

                                      

Count of unique data types

• So, now we have an overall idea about what are the data types that we are going to work with using the cars_data. 

• There is also an option where you can get the count of unique data types available in your Data Frame.

• So, in that case get_dtype_counts, returns the counts of unique data types in the data frame.

Here is the syntax.

Syntax = get_dtype_counts()

Selecting data based on data types

• So, now we also have an overall idea about the count of unique data types that we are going to handle with. 

• So, now, we know about how to get the data type of each variables. So, there might be cases where you want to perform the operations only on a numerical data type.

• Similarly, there can be cases where you are going to work with only categorical data type.

Here is the syntax.

Syntax = pandas.DataFrame.select.dtypes()

Join us: https://t.me/jupyter_python

Like us: https://www.facebook.com/pirawenpython

Read More

Wifi Password Generator in Python

WIFI PASSWORD EJECTOR

Description

• a simple python script that tells you the password of the wifi you're connected with

Requirements

• just need to install python in your system.

Source Code:- 

import subprocess

data = (

    subprocess.check_output(["netsh", "wlan", "show", "profiles"])

    .decode("utf-8")

    .split("\n")

)

profiles = [i.split(":")[1][1:-1] for i in data if "All User Profile" in i]

for i in profiles:

    results = (

        subprocess

        .check_output(["netsh", "wlan", "show", "profile", i, "key=clear"])

        .decode("utf-8")

        .split("\n")

    )

    results = [b.split(":")[1][1:-1] for b in results if "Key Content" in b]

    try:

        print("{:<30}|  {:<}".format(i, results[0]))

    except IndexError:

        print("{:<30}|  {:<}".format(i, ""))

Output:

Join us: https://t.me/jupyter_python

Like us: https://www.facebook.com/pirawenpython

Read More

Python Project [ Age_Calculator]

Calculate Your Age!

This script prints your age in three different ways :

1. Years
2. Months
3. Days

Prerequisites

You only need Python to run this script. You can visit here to download Python.

Input:

import time

from calendar import isleap

# judge the leap year

def judge_leap_year(year):

    if isleap(year):

        return True

    else:

        return False

# returns the number of days in each month

def month_days(month, leap_year):

    if month in [1, 3, 5, 7, 8, 10, 12]:

        return 31

    elif month in [4, 6, 9, 11]:

        return 30

    elif month == 2 and leap_year:

        return 29

    elif month == 2 and (not leap_year):

        return 28

name = input("input your name: ")

age = input("input your age: ")

localtime = time.localtime(time.time())

year = int(age)

month = year * 12 + localtime.tm_mon

day = 0

begin_year = int(localtime.tm_year) - year

end_year = begin_year + year

# calculate the days

for y in range(begin_year, end_year):

    if (judge_leap_year(y)):

        day = day + 366

    else:

        day = day + 365

leap_year = judge_leap_year(localtime.tm_year)

for m in range(1, localtime.tm_mon):

    day = day + month_days(m, leap_year)

day = day + localtime.tm_mday

print("%s's age is %d years or " % (name, year), end="")

print("%d months or %d days" % (month, day))

Output :

Join us: https://t.me/jupyter_python

Like us: https://www.facebook.com/pirawenpython

Read More

Python Project [Whatsapp Bot]

Whatsapp Bot

Perform Operation like

1. Put your details
2. connect with internet
3. Pass your message

Input:

import pywhatkit

from datetime import datetime

now = datetime.now()

chour = now.strftime("%H")

mobile = input('Enter Mobile No of Receiver : ')

message = input('Enter Message you wanna send : ')

hour = int(input('Enter hour : '))

minute = int(input('Enter minute : '))

pywhatkit.sendwhatmsg(mobile,message,hour,minute)

Output :

Join us: https://t.me/jupyter_python

Like us: https://www.facebook.com/pirawenpython

Read More

Python Project [ Digital Clock]

This script create a digital clock as per the system's current time.

Input:

import tkinter as tk
	from time import strftime
	def light_theme():
	frame = tk.Frame(root, bg="white")
	frame.place(relx=0.1, rely=0.1, relwidth=0.8, relheight=0.8)
	lbl_1 = tk.Label(frame, font=('calibri', 40, 'bold'),
	background='White', foreground='black')
	lbl_1.pack(anchor="s")
	def time():
	string = strftime('%I:%M:%S %p')
	lbl_1.config(text=string)
	lbl_1.after(1000, time)
	time()
	def dark_theme():
	frame = tk.Frame(root, bg="#22478a")
	frame.place(relx=0.1, rely=0.1, relwidth=0.8, relheight=0.8)
	lbl_2 = tk.Label(frame, font=('calibri', 40, 'bold'),
	background='#22478a', foreground='black')
	lbl_2.pack(anchor="s")
	def time():
	string = strftime('%I:%M:%S %p')
	lbl_2.config(text=string)
	lbl_2.after(1000, time)
	time()
	root = tk.Tk()
	root.title("Digital-Clock")
	canvas = tk.Canvas(root, height=140, width=400)
	canvas.pack()
	frame = tk.Frame(root, bg='#22478a')
	frame.place(relx=0.1, rely=0.1, relwidth=0.8, relheight=0.8)
	lbl = tk.Label(frame, font=('calibri', 40, 'bold'),
	background='#22478a', foreground='black')
	lbl.pack(anchor="s")
	def time():
	string = strftime('%I:%M:%S %p')
	lbl.config(text=string)
	lbl.after(1000, time)
	time()
	menubar = tk.Menu(root)
	theme_menu = tk.Menu(menubar, tearoff=0)
	theme_menu.add_command(label="Light", command=light_theme)
	theme_menu.add_command(label="Dark", command=dark_theme)
	menubar.add_cascade(label="Theme", menu=theme_menu)
	root.config(menu=menubar)
	root.mainloop()

Output :

Join us: https://t.me/jupyter_python

Like us: https://www.facebook.com/pirawenpython

Read More

Python Project [An application to save any random article from Wikipedia to a text file].

An application to save any random article from Wikipedia to a text file.

Output of the project

Source Code: 

from bs4 import BeautifulSoup

import requests

# Trying to open a random wikipedia article

# Special:Random opens random articles

res = requests.get("https://en.wikipedia.org/wiki/Special:Random")

res.raise_for_status()

# pip install htmlparser

wiki = BeautifulSoup(res.text, "html.parser")

r = open("random_wiki.txt", "w+", encoding='utf-8')

# Adding the heading to the text file

heading = wiki.find("h1").text

r.write(heading + "\n")

for i in wiki.select("p"):

    # Optional Printing of text

    # print(i.getText())

    r.write(i.getText())

r.close()

print("File Saved as random_wiki.txt")

Join us: https://t.me/jupyter_python

Like us: https://www.facebook.com/pirawenpython

Read More

Program that converts arrays into a list, loops through the list to form a string using the chr() function

Input :

#Program that converts arrays into a list, loops through the list to form a string using the chr() function

#clcoding.com

import numpy as np

def ord_to_character(words = ""):

    

    x = np.array([112,121,134,123,32,96,34,56,67,111,98,97,119,105,113])

    

    y = np.array([78,90,104,123,132,53,34,56,97,116,98,27,119,77,117,12])

    

    z = np.array([111,112,134,123,21,32,108,106,89,70,80,103,103,120,121])

    

    letters = x.tolist() + y.tolist()  + z.tolist()

    

    for letter in letters:

        words += chr(letter)

        

        

    return words 

sentence = ord_to_character()

print(sentence)

    

Output :

py†{ `"8CobawiqNZh{„5"8atbwMuop†{ ljYFPggxy

Join us: https://t.me/jupyter_python

Like us: https://www.facebook.com/pirawenpython

Read More