ISYS 363 Introduction to Python I

Web scraping is the automation of the extraction of large volumes of data from websites. Using Python, which of the following web scraping activities can be conducted?

Collect data from social media sites. Conduct price comparisons. Conduct research and development (R&D)

Marketing analytics are used to measure marketing performance and effectiveness and to make decisions on different strategies to increase marketing efficiency and impact. The analysis of marketing performance data can be enhanced using Python. Python is used for the analysis of which marketing related tasks?

A/B Testing Predictive analytics Customer segmentation analysis

A Python data science platform called Blank______ assists developers in finding cryptocurrency pricing data, the analysis of this information, and data visualization for use in decision making.

Anaconda

Select the true statements about how Python is used in finance.

Analytics in finance provides high-level and granular-level views of an organization's financial data. Python is used in quantitative and qualitative financial processes in many financial areas including analytics, banking, and cryptocurrency. Banks use Python to get financial models out of Excel and into an environment that allows for more data analysis and visualization.

Visual Basic for Blank______ (VBA) is included in Excel and offers the capability to create custom macros and functions that are designed to accomplish organizational specific tasks.

Applications

Select the true statements about the scalability of Microsoft Excel.

As the amount of spreadsheet tabs in a workbook increases, so does potential data management issues. When large volumes of data are introduced into Microsoft Excel, issues may occur. The management of small and medium scale data sets can be accomplished relatively smoothly.

Python is used in quantitative and qualitative financial processes in which of the following areas?

Banking Analytics Cryptocurrency

Because many business executives desire to create a data-driven decision-making culture, which three of the following are competencies organizations invest in to support DDDM?

Building a data-driven community Data proficiency Agility in analytics and data analysis

According to Tableau, data-driven decision making (DDDM) uses which of the following to guide strategic business decisions that align with organizational goals, objectives, and initiatives?

Data Facts Metrics

Which of the following is Microsoft Excel frequently used for?

Data visualization Data analytics Data entry

Which of the following Python libraries are used in marketing analytics and SEO?

ExPan TensorFlow

The three-step data visualization process is comprised of which of the following?

Explore data sets for patterns. Plan your visuals. Create your visuals.

Select the true statements about the business uses of Python.

Forty percent of recruiters are actively seeking Python programmers. Python is used in a variety of business disciplines including data analysis, finance, and accounting. A Python library is a collection of related programming modules that include pre-compiled bundles of code.

Data visualization is a strength of using Python for data analysis. Which of the following are types of data visualization that can be created using Python?

Graphics Interactive plots Charts

A/An _____ provides programmers the ability to work with Python and often consists of at least a source code editor, build automation tools, and a debugger.

IDE

Put the process for web scraping using Python in the correct order.

Identify URL Identify Data Inspect Locate Write/use Run Compile

Select the true statements about connectivity in Python.

Importing and exporting data is streamlined. Connections to external and internal data sources can be accomplished using Python. Python libraries such as pandas can interpret and merge data sets from different sources including Excel, CSV, and JASON.

Accountants use Python to automate which of the following repetitive tasks?

Input customer information Calculate taxes owed Input of invoices

Accountants use Python to automate which of the following repetitive tasks?

Input of invoices Calculate taxes owed Input customer information

When compared to Python, which of the following are considered limitations of using Microsoft Excel for data analysis?

Limited scalability Handling large volumes of data Syntax errors

Python was specifically designed to rely on which of the following?

Modules Python libraries

Microsoft Excel was first introduced in 1982 as a program called Blank______.

Multiplan

Known as numerical Python, Blank______ is well-suited for scientific computations and complex array operations and is widely used in data mining.

NumPY

Short for Financial Technology, FinTech refers to the use of technology and innovative solutions to automate and increase efficiency in which industries?

Payment systems Insurance Banking

Data manipulation in Python using the wide variety of libraries that are available offer accountants the ability to automate which of the following tasks?

Perform calculations. Analyze financial data. Generate reports.

The process of data analytics includes which of the following?

Prescriptive analytics Predictive analytics Descriptive analytics

Which of the following are popular Python IDEs?

PyCharm Spyder Visual Studio Code

A multi-purpose programming language that relies extensively on libraries and modules, ______ is suitable for the automation of various tasks and processes.

Python

Select the true statements about the Python programming language.

Python is completely free to use. Python syntax is considered by many to be relatively simple. Many people consider Python to be an ideal first programming language to learn.

Which of the following are business uses of the Python programming language?

Sales and marketing Accounting Finance

The steps in the data project life cycle, according to Harvard University's Data Science Ready project include which three of the following?

Sensing Wrangling Collection

Python has a wide array of tools and libraries specifically designed for data analysis. These assist in accomplishing which tasks?

Statistical analysis Data visualization Data manipulation

When compared to Microsoft Excel, which of the following are considered limitations of using Python for data analysis?

Steep learning curve associated with learning Python for data analysis. Not as friendly a user interface when compared to Microsoft Excel.

When compared to Python, which of the following are considered limitations of using Microsoft Excel for data analysis?

Syntax errors Limited scalability Handling large volumes of data

Select the true statements about the scalability of Python.

The number of columns or rows used in a data set does not impact the Python user because they are not operating in a data interface environment. Python can handle data sets of almost any scale. When working in Python, users can save data in separate files, which allows for simultaneous work and coding.

Which of the following are popular Python IDEs?

Visual Studio Code Spyder PyCharm

The process of investigating raw data of various types to uncover trends and correlations, and to answer specifically crafted questions is the role of data

analytics

Search Engine Optimization (SEO) involves the design (and improvement) of websites to increase non-paid visibility on search engines including Google and Bing. There is a Python script called the SEO _____ that is a web crawler designed to collect data from websites.

analyzer

The information technology (IT) architecture and infrastructure, software applications, programming languages, and storage technologies used for the collection, storage, analysis, and interpretation of meaningful data is referred to as the ______ ecosystem.

data

DDDM refers to data-driven _______ making.

decision

Trying to answer questions such as "what happened?" or "what is occurring?" or "what was the ROI?", is the role of ______.

descriptive analytics

In Microsoft Excel, a statement written by a user that is designed for a specific calculation is referred to as a ______.

formula

In Python, a collection of related programming modules that include precompiled bundles of code that can be used repetitively in different programs and applications are referred to as a Python Blank______. They often contain configuration data, templates, classes, values, and documentation.

library

The process of collecting, cleansing, transforming, and classifying data is referred to as data processing and

modeling

Python is ______ software based on community-based development that runs optimally on Windows and Linux operating systems

open-source

Derived from the term "panel data" that is used in econometrics, Blank______ includes a variety of modules designed to work with data.

pandas

Which of the following Python libraries are commonly used to automate accounting tasks?

pandas NumPy

Microsoft Excel is a spreadsheet software application that consists of a grid interface of columns and Blank______ where data can be entered, structured, and manipulated.

rows

One way to visualize a data ecosystem is to apply it to the data project life cycle. The Data Science Ready project outlines the five steps of the data project life cycle. The final stage in this life cycle is ______.

storage

A subset of data analysis that covers creating visual representations of data is referred to as data ______.

visualization

The graphical and structured representation of data is known as data

visualization