Intro to Data Analysis with Python

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

1. Identify the URL to scrape. 2. Identify the data that needs to be scraped. 3. Inspect the page. 4. Locate the data that needs to be extracted. 5. Write/use Python code to extract the data. 6. Run the code and extract the data. 7. Compile structured reports/visualizations of the data.

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

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?

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

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 the banking industry.

Banks use Python to get financial models out of Microsoft Excel. There is a Python script that allows for the creation of automatic recurring payment requests via Venmo. Python is used by financial institutions to provide online banking and payment processing systems.

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

Collection Sensing Wrangling

Select the true statements about connectivity in Python.

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

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

Cryptocurrency Banking Analytics

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

The process of data analytics includes which of the following?

Descriptive analytics Predictive analytics Prescriptive analytics

Which Python web frameworks identified in the text assist in the development of scalable and secure FinTech web applications?

Django Flask

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.

Field 1: data or Data

The graphical and structured representation of data is known as data

Field 1: visualization, Visualization, or visualizations

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 manipulation in Python using the wide variety of libraries that are available offer accountants the ability to automate which of the following tasks?

Generate reports. Analyze financial data. Perform calculations.

The Python programming language was developed in the 1980s by

Guido van Rossum

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

Input of invoices Input customer information Calculate taxes owed

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?

Interactive plots Graphics Charts

API stands for Application Programming Blank______ and allows for different software programs the ability to connect and work with each other.

Interface

Select the true statements about the Python programming language.

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

Select the true statements about connectivity in Microsoft Excel.

Microsoft Excel is a solid option for users importing and exporting basic reports. Connections to cloud-based data is possible. Workbooks can be connected to external data sources including SQL servers.

Microsoft Excel was first introduced in 1982 as a program called

Multiplan

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

Python

Python is designed to work with which of the following?

Python libraries Modules

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

Sales and marketing Accounting Finance

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 Handling large volumes of data Limited scalability

Select the true statements about the scalability of Microsoft Excel.

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

Select the true statements about the scalability of Python.

When working in Python, users can save data in separate files, which allows for simultaneous work and coding. 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.

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 three-step data visualization process consists of exploring the data sets for pattern, then planning for visuals, and finally ___.

creating your visuals

Similar to how mining recovers small amounts of precious metals from large amounts of ore or earth, Blank______ is the process of extracting information from large data sets

data mining

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 Microsoft Excel, a predefined formula that is built into the software for ease of use and deployment is referred to as a

function

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

modeling

Python is Blank______ 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

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

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

visualization