nhk23 / master-aidm7360 Goto Github PK

You'd better install vscode, because other complier may lead some error information, like pycharm.
All dataset must be put into data folder.
Airbnb_Open_Data.csv This file is our dataset
BOSTON.csv This file is our test dataset, it just want to tell you our data can change, the template are not unchange.

1. Put all the group project in your compiler
2. Run main.py
3. It can automatic read uniform type csv file and write into database
 
Operation as following:
1. Update data                 you can input 'update' or 'Update' or 'UPDATE' or '1'
2. Delete data                   you can input 'DELETE' or 'Delete' or 'delete' or '2' 
3. Insert data                    you can input 'Insert' or 'INSERT' or 'insert' or '3'
4. Get report and Exit        you can input 'Exit' or 'EXIT' or 'exit' or '4'

Get into delete module:
1. Delete xx table			you can input 'Table' or 'table' or 'TABLE' or '1'
2. Delete xx table xx data		you can input '2' or 'Data' or 'data' or 'DATA'
3. Exit                                       you can input '3' or 'Exit' or 'EXIT' or 'exit'
Get into update module:
1. Update Template table          you have to input 'Template'
2. Update Host_Info table          you have to input 'Host_Info'
3. Update other columns           you can directly input right table name
4. Exit                                        you have to input '3'
Get into insert module:
1. Insert House_info table
2. Insert Host_Info table
3. Insert Host_Location table
4. Insert Platform table
5. Insert Fee table
6. Insert User table
7. Insert Connect table


pip install seaborn
pip install folium
pip install selenium
pip install pandas