In the digital age, artificial intelligence (AI) has become a game-changer in many fields, including communication and productivity. One such AI tool that has made a significant impact is Microsoft’s Copilot, formerly known as Bing Chat and Bing Chat Enterprise. Copilot is a chat AI platform developed by Microsoft. It uses advanced AI algorithms to… Continue reading Microsoft’s Copilot-Bing Chat
Category: AI
Removal of Headers of CSV file from the Current Working Directory
Python program for removing headers from csv files import csv,os os.makedirs(‘headerRemoved’, exist_ok=True) #loop through every file in the current working directory for fileName in os.listdir(‘.’): if not fileName.endswith(‘.csv’): continue print(‘Removing Header From CSV’+fileName) #read the csv file skipping the first row csvRows=[] csvFileObj=open(fileName) readObj=csv.reader(csvFileObj) for row in readObj: if readObj.line_num ==1: continue csvRows.append(row) csvFileObj.close()… Continue reading Removal of Headers of CSV file from the Current Working Directory
Multiplication Table Maker
Create a program multiplicationTable.py that takes a number N from the command line and creates an N×N multiplication table in an Excel spreadsheet. import sys import openpyxl from openpyxl.styles import Font if len(sys.argv) != 2: print(“Usage: python multiplicationTable.py <N>”) else: n = int(sys.argv[1]) # Create a new workbook and select the active sheet wb =… Continue reading Multiplication Table Maker
Updating excel document using python
we already have an excel document namely produceSales and we need to update it with new values.Without searching each item we can done it through python programming Code: import openpyxl wb=openpyxl.load_workbook(‘produceSales.xlsx’) print(‘—-workbook opened—‘) produce_update={‘Garlic’: 3.07,’Celery’: 1.19,’Lemon’: 1.27} sheet=wb[‘Sheet’] for rows in range(2,sheet.max_row+1): product=sheet.cell(row=rows,column=1).value if product in produce_update: sheet.cell(row=rows,column=2).value=produce_update[product] wb.save(‘updatedProduceSales.xlsx’) print(“Update completed”)
Encrypt a pdf using python
Code to encrypt a pdf using python: import PyPDF2 pdfFile = open(‘meetingminutes.pdf’, ‘rb’) pdfReader = PyPDF2.PdfFileReader(pdfFile) pdfWriter = PyPDF2.PdfFileWriter() for pageNum in range(pdfReader.numPages): pdfWriter.addPage(pdfReader.getPage(pageNum)) pdfWriter.encrypt(‘swordfish’) resultPdf = open(‘encryptedminutes.pdf’, ‘wb’) pdfWriter.write(resultPdf) resultPdf.close()
Testim
Testim is a modern test automation platform that leverages artificial intelligence (AI) to simplify the test automation process and enhance test maintenance. It is designed to help software development teams create and maintain tests more efficiently, reducing the effort required for test script creation and maintenance. Key features of Testim include: AI-Powered Test Automation: Testim… Continue reading Testim
Python code for creating a quiz generator with 35 different form contains same question but different order to prevent cheating.
import random # The quiz data. Keys are states and values are their capitals. capitals={‘Alabama’: ‘Montgomery’, ‘Alaska’: ‘Juneau’, ‘Arizona’: ‘Phoenix’, ‘Arkansas’: ‘Little Rock’, ‘California’: ‘Sacramento’, ‘Colorado’: ‘Denver’,’Connecticut’: ‘Hartford’, ‘Delaware’: ‘Dover’, ‘Florida’: ‘Tallahassee’, ‘Georgia’: ‘Atlanta’, ‘Hawaii’: ‘Honolulu’, ‘Idaho’: ‘Boise’, ‘Illinois’: ‘Springfield’, ‘Indiana’: ‘Indianapolis’, ‘Iowa’: ‘Des Moines’, ‘Kansas’: ‘Topeka’, ‘Kentucky’: ‘Frankfort’, ‘Louisiana’: ‘Baton Rouge’, ‘Maine’: ‘Agusta’, ‘Maryland’:… Continue reading Python code for creating a quiz generator with 35 different form contains same question but different order to prevent cheating.