CHAPTER 4
PANDAS AND SQL
This chapter contains a variety of Python code samples that contain Pandas, SQL, and SQLite3. You will also see examples of working with XML documents and JSON data in Python code samples.
The first section contains code samples of data visualization in Pandas, such as bar charts, area charts, and line graphs.
The first section contains code samples of data visualization in Pandas, such as bar charts, area charts, and line graphs.
The second section contains code samples that show you how to write Python code that contains MySQL commands. You will also see code samples that contain Python and Pandas. In addition, you will learn how to export SQL data from Pandas to an Excel spreadsheet.
The third section briefly introduces XML and JSON, and how to read such data in a Pandas DataFrame. Moreover, there is section that discusses regular expressions.
The fourth section shows you how to combine Python and SQLite to perform database-related operations, such as creating...