Shulou(Shulou.com)06/01 Report--

This article will explain in detail how to operate the class excel in two-dimensional dataframe. The content of the article is of high quality, so the editor will share it with you for reference. I hope you will have a certain understanding of the relevant knowledge after reading this article.

Introduction to pandas

Pandas is one of the most classic libraries in the field of python data analysis, which is based on numpy.

The data structures commonly used in pandas are:

1century Series: an one-dimensional array with index. Only data of the same type is allowed to be stored in Series.

2Magna DataFrame: two-dimensional tabular data structure. You can think of DataFrame as a container for Series.

3Jing Panel: a three-dimensional array. Can be understood as a container of DataFrame.

Did you find the relationship between the name of the pandas library and the names of these three data structures? We introduce DataFrame in this section and the following sections. DataFrame is the most widely used data structure of python in the field of data analysis. It has the following advantages:

The data is intuitive-it's like an excel table.

Powerful-extremely rich methods

The summary of DataFrame is as follows:

DataFrame is a Series container that is created and indexed much like Series.

DataFrame can be thought of as an array with index and columns names and supports vectorization.

You can manipulate DataFrame like an excel table: insert rows and columns, sort, filter...

You can manipulate DataFrame in the same way as SQL tables: query, group, join...

In this section, we introduce the excel-like operation of DataFrame.

One, import and export

1, import excel table

2, export the excel table

Second, add and delete ranks

1, add lines

2, delete rows

3, add columns

4, delete column

5, move rows and columns

Third, sort

1, sort by column value

2, sort by index and column name

Fourth, draw a chart

Use dataframe's plot method to draw various types of charts: line chart, column chart, pie chart, scatter chart, density chart, contour map and so on. This drawing function is realized by calling the matplotlib library. We will explain the method of drawing with dataframe in depth when we introduce matplotlib.

On the two-dimensional dataframe class excel operation is shared here, I hope that the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.