This essay focuses on a form that is efficient for movement. Understand dataset with data scientist mind-set. ● Understand and design computation logic
You are to include the following particulars in your submission: Course Code, Title of the TMA, SUSS PI No., Your Name, and Submission Date. Answer all questions. (Total 100 marks) Question 1 (47 marks) Objectives: ● Understand dataset with data scientist mind-set. ● Understand and design computation logic and routines in Python. ● Assess use of Python only and Python data structures to perform extract, load, and transformation operations. ● Assess the design and use of database SQL and methods to perform extract, load, transformation and calculation operations. ● Structure code in appropriate methods (functions), looping and conditions. (a) From tweets.json, find and apply all entity types using Python code. For example, hashtag is one entity type. (2 marks) (b) Create the tweets schema and store tweets in tweets.json file to a SQLite database. The tweets schema contains the following fields: id, created_at, full_text, favorite_count and retweet_count.
The field id is the primary key. (5 marks) (c) Compose and create schema and store data. (i) Create the entities schema with the following fields and requirements: In computing, data is information that has been translate into a form that is efficient for movement or processing .Since the invention of computers, people have used the term data to refer to computer information, and this information was either transmitted or stored. But that is not the only data definition; there exist other types of data as well. So, what is the data? Data can be texts or numbers written on papers, or it can be bytes and bits inside the memory of electronic devices, or it could be facts that are stored inside a person’s mind. And in this article, we will cover the following topics in detail