Untitled

mail@pastecode.io avatar
unknown
plain_text
a year ago
6.7 kB
1
Indexable
Never
import matplotlib.pyplot as plt
from sqlalchemy import create_engine
my_conn=create_engine("mysql+mysqldb://root:pervysage2004@localhost/project")
import pandas as pd
import webbrowser as wb
import numpy as np
d1={'Driver':['Mangal','Ayush','Shrey','Nakul','Darsh','Dhruv','Arnab','Praveen','Nitin','Mayank'],
             'ID':[2314,5543,6789,2378,1234,6699,6969,1023,9872,6102],
             'Distance Covered (KM)':[106,506,1500,23,45,77,893,123,156,223],
             'Charge Per KM':[10,9,15,13,12,22,25,20,10,11],
             'Area':['Noida','Noida','Delhi','Delhi','Gurgaon','Delhi','Noida','Delhi','Noida','Gurgaon']}
df=pd.DataFrame(d1)
d2={'Mangal':9971822778,'Ayush':9627804321,'Shrey':9627804030,'Nakul':9255678910,'Darsh':9081762369,'Dhruv':9010225578,'Arnab':8970554422,'Praveen':9971822775,'Nitin':9976129045,'Mayank':9837188555}
d3={'Mangal':'Swift/UP265378','Ayush':'Ertiga/UP266908','Shrey':'i10/DL1C8264','Nakul':'Scorpio/DL1C5612','Darsh':'Indica/HR261324','Dhruv':'Bolero/DL1C6689','Arnab':'i20/UP264569','Praveen':'Honda City/DL1C7472','Nitin':'Camry/UP269009','Mayank':'Santro/HR265873'}
s1=pd.Series(d2)
s2=pd.Series(d3)
n=input('Enter Your Name: ')
print(f'Welcome {n}!')
print('Welcome To Menu,Here are the commands you can run: ')
print('1.Cab Booking')
print('2.DataFrame View')
print('3.Visualization Of The Dataframe')
print('4.Alter Dataframe')
print('5.Exit')
k=int(input('Choose The Command:'))
if k==0 or k>5:
    while k==0 or k>5:
        print('1.Cab Booking')
        print('2.DataFrame View')
        print('3.Visualization Of The Dataframe')
        print('4.Alter Dataframe')
        print('5.Exit')
        k=int(input('Please Choose From The Following:'))
while k>=1 and k<=5:
    if k==1:
            print('Welcome to Uber Where Rides are Convenient for Everyone ')
            print('type 0 if want to quit booking')
            l=int(input('Enter Number of Booking: '))
            for i in range(0,l,1):
                if l=='0':
                    break;
                print('Areas we operate in:','\nDelhi','\nGurgaon','\nNoida')
                b=input('Please select your Area:')
                d=b.capitalize()
                print('Drivers near your location along their charges:')
                print(df.loc[df['Area']==d,['Driver','Charge Per KM']])
                print('Select Your Driver As Per Your Convenience By Typing their respective Number')
                print('example','\n0 or 7')
                c=int(input('Enter:'))
                dr=df['Driver'][c]
                print(f'Your Driver Is:{dr}')
                print('Here Are The Details Of Your Driver :')
                print(s1[dr])
                print(s2[dr])
                e=input('Enter Place You Want To Reach: ')
                print('Below You will find the link to google maps pls click on it to enter the place and tell the distance to be covered')
                link=wb.open('https://www.google.com/maps/')
                print(link)
                f=int(input('Enter Distance: '))
                pr=d1['Charge Per KM'][c]
                pr=np.array(pr)
                pr=int(pr)
                pr=pr*f
                print(f'Your Price Is:{pr} ')
                print('Thank You For Booking and Enjoy Your Trip!')
                df.loc[c,'Distance Covered (KM)']=df.loc[c,'Distance Covered (KM)']+f
            print('Booking Over')
            print('Updated The Dataframe in terms of distance covered')
            z=input('Do You Wish To see The Updated Dataframe?[Y/N]:')
            z=z.capitalize()
            if z=='Y':
                print(df)
                print()
    elif k==4:            
        print('1.Adding new records')
        print('2.Deleting records')
        s=int(input('Please Select the following:'))
        while s==1 or s==2:
            if s==1:
                print(df)
                print('Please give the details accordingly')
                l1=[]
                for p in range(1,6):
                    q=input('Enter value:')
                    l1.append(q)
                l1[1]=int(l1[1])
                l1[2]=int(l1[2])
                df.loc[len(df)]=l1
                print('Updated dataframe')
                print(df)
            if s==2:
                q=input('Please tell if u wanna delete row or column:[R/C]:')
                q=q.capitalize()
                if q=='R':
                    print('Which row u wanna delete from the following')
                    print(df)
                    z=df.index
                    z=z.tolist()
                    print(z)
                    w=int(input('Enter:'))
                    df.drop(labels=[w],inplace=True)
                    print('Updated dataframe')
                    print(df)
                elif q=='C':
                    print('which column you wanna delete')
                    print(df)
                    z=df.columns
                    z=z.tolist()
                    print(z)
                    w=input('Enter:')
                    df.drop(columns=[w],inplace=True)
                    print('Updated dataframe')
                    print(df)
            print('enter 0 to quit the alteration')
            print('1.Adding new records')
            print('2.Deleting records')
            s=int(input('Please Select the following:'))
    elif k==2:
        print('The Database:')
        print()
        print(df)
    elif k==3:
        pass;
        a=df.Area
        b=[]    
        plt.bar(a,b,color='b')
        plt.xlabel('city we operate')
        plt.ylabel('no. of drivers present in that city')
        plt.title('Driver available in the city we operate in ')
        plt.show()
        x=df.Driver
        y=df.Distance Covered (KM)
        plt.plot(x,y,color='r')
        plt.xlabel('DRIVERS')
        plt.ylabel('DISTANCE THEY COVERED')
        plt.title('EACH DRIVER AND DISTANCE THEY COVERED')
        plt.show()
        p=df.Driver
        q=df.Charge Per KM
        plt.bar(p,q,color='g')
        plt.xlabel('DRIVERS')
        plt.ylabel('CHARGE PER KM')
        plt.title('EACH DRIVER AND DISTANCE THEY CHARGE')
        plt.show()
    else:
        print('Session Over')
        break;
    print('1.Cab Booking')
    print('2.DataFrame View')
    print('3.Visualization Of The Dataframe')
    print('4.Alter Dataframe')
    print('5.Exit')    
    k=int(input('Please Choose From The Following:'))     
df.to_sql(con=my_conn,name='project',if_exists='replace',index=False)