Registering Client for ZOHO integration in ZOHO Developer console

Before get started with authorization and make any calls using the Zoho CRM APIs, we need to register application with Zoho CRM. To register, Go to Zoho Developer Console. Choose a client type: Java Script: Applications that run exclusively on a browser and are independent of a web server. Web Based: Applications that are clients running on a dedicated… Continue reading Registering Client for ZOHO integration in ZOHO Developer console

Access Token and Refresh token generation using ZOHO CRM

To generate, first we need to make register the client and obtain client Id and client secret. Once it generated, we need to make an authorization request of the form. “https://accounts.zoho.in/oauth/v2/auth?response_type=code&client_id=1000.YER1ZKFUZAJ9S53P8ZIZ09MSZMPFMG&scope=ZohoCRM.modules.ALL&redirect_uri=https://td2896732.app.netsuite.com/app/common/scripting/scriptrecord.nl?id=2358&access_type=offline” type this in a web browser and zoho access page will open, accept this. Then it will redirect to the implementation page of our… Continue reading Access Token and Refresh token generation using ZOHO CRM

Hosting Of a Django Application Using Plesk webserver

To set up Django on Plesk: First of all, let’s check Python presence in the system. we can do it by issuing the command: python –version Install a Python package manager (under the “root” user): apt-get install python-pip It is common practice to have a separate virtual environment for each Python application. So, let’s install… Continue reading Hosting Of a Django Application Using Plesk webserver

Building a Django Application with Google Routing and Geocoding API

In the realm of web development, incorporating mapping functionalities into applications has become increasingly popular. Google Maps APIs provide a powerful toolkit for developers to integrate mapping, geocoding, and routing capabilities seamlessly into their web applications. In this article, we will explore how to leverage Django, a high-level Python web framework, along with Google Routing… Continue reading Building a Django Application with Google Routing and Geocoding API

Map Box Api for Geocoding

Mapbox APIs are much more than just map tiles. They hold the key to unlocking a rich world of location-based possibilities, enriching your applications and engaging your users in innovative ways. This article delves deeper into the diverse capabilities of Mapbox APIs, showcasing their potential beyond the standard map visualization. From Static to Interactive: Imagine… Continue reading Map Box Api for Geocoding

Visualizing Geospatial Data using Folium in Python

In the realm of data visualization, maps have proven to be an invaluable tool for conveying complex spatial information. While Python boasts an impressive collection of data visualization libraries, Folium stands out as a powerful and user-friendly library specifically designed for creating interactive maps. What is Folium? Folium is a Python wrapper for Leaflet.js, a… Continue reading Visualizing Geospatial Data using Folium in Python

Microsoft’s Copilot-Bing Chat

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

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

Published
Categorized as AI Tagged

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”)

Published
Categorized as AI Tagged