Unit 1: Data Handling using Pandas - I
37 Questions
0 Views

Choose a study mode

Play Quiz
Study Flashcards
Spaced Repetition
Chat to lesson

Podcast

Play an AI-generated podcast conversation about this lesson

Questions and Answers

Which SQL command is part of DDL?

  • INSERT
  • UPDATE
  • SELECT
  • CREATE (correct)
  • The function POWER(x, y) returns x raised to the power of y.

    True

    What does the function LENGTH() return?

    The length of a string

    The ______ function is used to find the position of a substring.

    <p>INSTR</p> Signup and view all the answers

    Match the following SQL functions with their descriptions:

    <p>MAX() = Returns the maximum value in a set. AVG() = Calculates the average of a set. COUNT() = Counts the number of rows. SUM() = Calculates the total of a set.</p> Signup and view all the answers

    Which function would you use to extract just the date from a datetime value?

    <p>DATE()</p> Signup and view all the answers

    The function ROUND(x, d) rounds x to d decimal places.

    <p>True</p> Signup and view all the answers

    What does the SQL command 'DROP' do?

    <p>Removes a table or database</p> Signup and view all the answers

    What is the main purpose of the Pandas library in Python?

    <p>Data manipulation and analysis</p> Signup and view all the answers

    A DataFrame in Pandas is a one-dimensional labeled array.

    <p>False</p> Signup and view all the answers

    What function would you use to display the first few elements of a Pandas Series?

    <p>head()</p> Signup and view all the answers

    To create a Pandas Series from a dictionary, use the command pd.Series({___}).

    <p>key: value pairs</p> Signup and view all the answers

    Match the following Pandas operations with their descriptions:

    <p>head() = Displays the first few elements tail() = Displays the last few elements loc[] = Access data via label df[df['col'] &gt; value] = Boolean indexing</p> Signup and view all the answers

    Which of the following methods can be used to read a CSV file into a DataFrame?

    <p>pd.read_csv('file.csv')</p> Signup and view all the answers

    A bar graph is created using the function plt.hist(x, y).

    <p>False</p> Signup and view all the answers

    What is the command used to save a plot as a PNG file in Matplotlib?

    <p>plt.savefig('filename.png')</p> Signup and view all the answers

    Which of the following is an example of Free and Open Source Software (FOSS)?

    <p>Linux</p> Signup and view all the answers

    Copyright provides legal protection against unauthorized use of a creator's work.

    <p>True</p> Signup and view all the answers

    What are the key features of the Indian IT Act, 2000?

    <p>Legal recognition of digital signatures, prevention of cybercrime, penalizes hacking and data theft.</p> Signup and view all the answers

    Disposing of electronic devices in an environmentally safe manner is part of e-waste __________.

    <p>management</p> Signup and view all the answers

    Match the following types of cyber threats with their descriptions:

    <p>Hacking = Gaining unauthorized access to a system Phishing = Fraudulent attempts to steal sensitive information Cyber Bullying = Harassment using digital platforms Identity Theft = Stealing someone's personal information for fraudulent purposes</p> Signup and view all the answers

    What is the primary function of an Equi-Join in databases?

    <p>Combines rows from two tables based on a matching column</p> Signup and view all the answers

    A LAN (Local Area Network) can cover multiple towns.

    <p>False</p> Signup and view all the answers

    What device is used to convert digital data to analog for transmission?

    <p>Modem</p> Signup and view all the answers

    A __________ connects different networks and routes data between them.

    <p>Router</p> Signup and view all the answers

    Match the following network topologies with their characteristics:

    <p>Star Topology = Devices connected to a central hub Bus Topology = Devices connected in a linear sequence Mesh Topology = Every device connected to every other device Tree Topology = Hierarchical combination of star and bus topologies</p> Signup and view all the answers

    Which of the following defines a PAN (Personal Area Network)?

    <p>A small network for personal devices</p> Signup and view all the answers

    The World Wide Web is synonymous with the Internet.

    <p>False</p> Signup and view all the answers

    What does VoIP stand for?

    <p>Voice over Internet Protocol</p> Signup and view all the answers

    What defines a website?

    <p>A collection of related web pages</p> Signup and view all the answers

    Dynamic webpages have fixed content.

    <p>False</p> Signup and view all the answers

    Name two types of digital footprints.

    <p>Active and Passive</p> Signup and view all the answers

    A ______ is used to access information on the web.

    <p>web browser</p> Signup and view all the answers

    Match the following concepts with their definitions:

    <p>Cookies = Small data files stored on a user's computer Intellectual Property Rights = Legal rights protecting creations of the mind Data Protection = Safeguarding personal data from unauthorized access Plagiarism = Using someone else's work without proper credit</p> Signup and view all the answers

    Which of the following methods can help protect data?

    <p>Enabling two-factor authentication</p> Signup and view all the answers

    Net and Communication Etiquettes encourage spamming.

    <p>False</p> Signup and view all the answers

    What can lead to legal consequences and loss of credibility?

    <p>Plagiarism</p> Signup and view all the answers

    Study Notes

    Unit 1: Data Handling using Pandas - I

    • Pandas is a Python library for data manipulation and analysis.
    • Matplotlib is a library for creating visualizations.
    • Series is a one-dimensional labeled array for holding data of any type.
    • DataFrame is a two-dimensional, mutable, heterogeneous tabular data structure.
    • Series creation methods include from ndarrays, dictionaries, and scalar values.
    • Series operations include mathematical operations like addition, subtraction, multiplication.
    • Functions like head() display initial elements, and tail() displays the last few.
    • Series data can be selected, indexed, and sliced.
    • DataFrame creation includes from dictionaries of series or lists of dictionaries.
    • DataFrame operations include adding, selecting, deleting columns/rows.
    • DataFrames can be indexed using labels (df.loc[]) or boolean indexing (df[df['col'] > value]).
    • Data can be imported from and exported to CSV files, using pd.read_csv() and df.to_csv(). Exporting should typically exclude row indexes (e.g., index=False).

    Unit 2: Database Query using SQL

    • Databases are structured collections of data.
    • SQL is used to interact with databases.
    • SQL commands include DDL (CREATE, ALTER, DROP) and DML (SELECT, INSERT, UPDATE, DELETE) with other elements of transaction control language.
    • Mathematical functions in SQL include POWER, ROUND, and MOD.
    • Text functions include UCASE/UPPER, LCASE/LOWER, MID/SUBSTRING/SUBSTR, LENGTH, LEFT, RIGHT, and INSTR.
    • Date functions include NOW, DATE, MONTH, MONTHNAME, YEAR, DAY, and DAYNAME.
    • Aggregate functions include MAX, MIN, AVG, SUM, and COUNT.
    • GROUP BY groups rows with shared properties.
    • HAVING filters groups of data.
    • ORDER BY sorts the results.

    Unit 3: Introduction to Computer Networks

    • Networks connect devices for resource sharing and communication.
    • Network types include PAN (Personal Area), LAN (Local Area), MAN (Metropolitan Area), and WAN (Wide Area).
    • Key network devices include modems, hubs, switches, repeaters, routers, and gateways.
    • Common network topologies include bus, tree, and mesh topologies.
    • The internet is a global network of interconnected networks.
    • URL is a web resource locator and WWW is a system of interconnected hypertext documents.
    • Internet applications include web browsing, email, chat, and VoIP.

    Unit 4: Societal Impacts

    • Digital footprint is the trail of data left by internet users. This includes activities like social media posts, search history, and cookies.
    • Digital footprint types include active (intentionally shared info) and passive (data collected without user awareness).
    • Net etiquette guidelines concern respectful communication online.
    • Data protection involves methods to safeguard data from unauthorised access.
    • Intellectual Property Rights (IPR) secures creations (inventions, art, designs). Rights include patents, copyright, and trademarks.
    • Plagiarism is using someone else's work without proper acknowledgement.
    • Licensing and copyright involve legal protections and permissions to use copyrighted content.

    Unit 7: Free and Open Source Software (FOSS)

    • FOSS (Free and Open Source Software) is freely modifiable and distributed software.
    • Examples include Linux, Apache, and LibreOffice.
    • Benefits include cost-effectiveness, collaboration, and no vendor lock-in.

    Unit 8: Cybercrime and Cyber Laws

    • Cybercrime refers to illegal activities involving computers and the internet (e.g., hacking, phishing, identity theft).
    • Indian Cyber laws are governed by the Indian IT Act, 2000. Key aspects include digital signature recognition, cybercrime prevention, and penal provisions.

    Unit 9: Types of Cyber Threats

    • Hacking is gaining unauthorised access to a system.
    • Phishing is fraudulent attempts to steal sensitive information through fake emails/websites.
    • Cyber bullying is harassment using digital platforms.

    Unit 10: E-Waste

    • E-waste refers to discarded electronic devices, harmful due to toxic components.
    • Effective management includes recycling, refurbishing, and safe disposal.
    • Excessive technology use can cause physical (e.g., eye strain, carpal tunnel) and mental issues (e.g., stress, social isolation).
    • Solutions exist to mitigate these concerns (e.g., ergonomic equipment, 20-20-20 rule).

    Studying That Suits You

    Use AI to generate personalized quizzes and flashcards to suit your learning preferences.

    Quiz Team

    Related Documents

    Python Pandas Data Handling PDF

    Description

    This quiz covers the basics of data handling using the Pandas library in Python. It includes topics like Series and DataFrame creation, manipulation, and key functions for data analysis and visualization. Prepare to test your understanding of core concepts and operations involved in data manipulation.

    More Like This

    Pandas Library for Data Analysis
    11 questions
    Pandas Introduction
    11 questions

    Pandas Introduction

    ClearerHouston avatar
    ClearerHouston
    Pandas Library for Data Handling
    40 questions
    Use Quizgecko on...
    Browser
    Browser