Data Analysis Using Python
Our project title is “Data Analysis Using Python”. This project is to analyse the pieces of information from Microsoft Excel. “sales = pd.read_csv('sales.csv')” is the code to input or read the information from the Microsoft Excel file. The file is named 'sales.csv' and it contains info about invoice ID, date, time, gender, location, city, member, category, price, quantity, total sales, payment preference and ratings.
Then, we sort a dataframe to make the information arrange better and more systematic. The result of the dataframe is shown below.
Next, we get the number of cities, location, category and payment, and also sort the number of locations based on city. We count the number of invoice IDs for several locations and slit sales dataframe based on location. Moreover, we sort for the category and then sum all the total sales for similar categories based on location.
Besides, we create Table 1 and a graph to show the total sales and rating based on location and city. Table 1 and the graph are shown below.
We also create a graph for Table 2 that shows total sales and ratings according to city and category. The results are shown below.
Finally, we create a graph for Table 3 that shows total sales and ratings based on city. The results are shown below.
In short, data analysis can be done by using Python to create a table and a graph so that the results are easier to look at and understand rather than finding the information from the input file.
About Us
Robotics Club USM, is a gathering/club that provide a platform for students who are interested to learn, research, and development about robot. In USM, Robotics Club is a club which is under the supervision of School of Electrical and Electronic Engineering. However, the club also consists of members from various schools for instance School of Mechanical Engineering, School of Chemical Engineering and etc. Basically this club is one of the clubs wholly organized by students where lecturers act as managers.
Recently, USM Robotics Club mainly focuses on Research and Development (R&D) to develop new technology to apply in the robotics for solving some specific tasks. By having R&D department, we manage to improve our technology level to get a better performance for our robots.
Hopefully with these skills and knowledge our members gain from here, they can develop a new and useful technology to have a better life for human-being in future.
