[Data analysis tool] Pandas function introduction (I), data analysis pandas
If you are using Pandas (Python Data Analysis Library), the following will certainly help you.
First, we will introduce some simple concepts.
DataFrame: row and column data, similar to sheet in Excel or a relational database table
Series: Single Column data
Axis: 0: Row, 1: Column
[Data cleansing]-clean "dirty" data in Pandas (3) and clean pandasPreview Data
This time, we use Artworks.csv, And we select 100 rows of data to complete this content. Procedure:
DataFrame is the built-in data display structure of Pandas, and the display speed is very fast. With DataFrame, we can quickly preview and analyze data. The Code is as follows:
import pandas
First of all, pandas's author is the author of this book.For NumPy, the object we are dealing with is the matrixPandas is encapsulated based on the NumPy, pandas is a two-dimensional table (tabular, spreadsheet-like), and the difference between the matrix is that the two-dimensional table is a meta-dataUsing these meta-data as index is more convenient, and
The previous Pandas array (Pandas Series)-(3) Vectorization, said that when the two Pandas series were vectorized, if a key index was only in one of the series , the result of the calculation is nan , so what is the way to deal with nan ?1. Dropna () method:This method discards all values that are the result of NaN , which is equivalent to calculating only the va
This article mainly introduces how to use Python pandas framework to operate data in Excel files, including basic operations such as unit format conversion and classification and Summarization. For more information, see
Introduction
The purpose of this article is to show you how to use pandas to execute some common Excel tasks. Some examples are trivial, but I think it is equally important to present these
--------------------------------------------------------------------------------------
Blog:http://blog.csdn.net/chinagissoft
QQ Group: 16403743
Purpose: Focus on the "gis+" cutting-edge technology research and exchange, the cloud computing technology, large data technology, container technology, IoT and GIS in-depth integration, explore the "gis+" technology and industry solutions
Reprint Note: The article is allowed to reprint, but must be linked to the source address, otherwise held legal res
Common basic numpy operations and numpy operations
The dimension of the NumPy array is called rank. The rank of the one-dimensional array is 1, the rank of the Two-dimensional array is 2, and so on. In NumPy, each linear array is called an axis, and the rank is actually the number of axes. For example, a two-dimensiona
PandasPandas is the most powerful data analysis and exploration tool under Python. It contains advanced data structures and ingenious tools that make it fast and easy to work with data in Python. Pandas is built on top of NumPy, making numpy-centric applications easy to use. Pandas is very powerful and supports SQL-lik
, how to do? For more information please go to other blogs, where more detailed instructions are available .Pandas import time data for format conversion Draw multiple graphs on one canvas and add legends1 fromMatplotlib.font_managerImportfontproperties2Font = fontproperties (fname=r"C:\windows\fonts\STKAITI. TTF", size=14)3colors = ["Red","Green"]#the color used to specify the line4Labels = ["Jingdong","12306"]#used to specify the legend5Plt.plot (
Sometimes you need to do some work on the values in the Pandas series , but without the built-in functions, you can write a function yourself, using the Pandas series 's apply method, You can call this function on each value inside, and then return a new SeriesImport= PD. Series ([1, 2, 3, 4, 5])def add_one (x): return x + 1print s.apply ( Add_one)# results:0 6dtype:int64A chestnut:Names =PD. Serie
Data conversionDelete duplicate elements The duplicated () function of the Dataframe object can be used to detect duplicate rows and return a series object with the Boolean type. Each element pairsshould be a row, if the row repeats with other rows (that is, the row is not the first occurrence), the element is true, and if it is not repeated with the preceding, the metaThe vegetarian is false.A Series object that returns an element as a Boolean is of great use and is particularly useful for fil
The pandas of Python is simply introduced and used
Introduction of Pandas
1. The Python data analysis Library or pandas is a numpy based tool that is created to resolve data profiling tasks. Pandas incorporates a large number of libraries and standard data models that provi
This article describes how to use the pandas library in Python to analyze cdn logs. It also describes the complete sample code of pandas for cdn log analysis, then we will introduce in detail the relevant content of the pandas library. if you need it, you can refer to it for reference. let's take a look at it.
Preface
A requirement encountered in recent work is
This article describes how the pandas series with the index index is vectorized:1. Index indexed arrays are the same:S1 = PD. Series ([1, 2, 3, 4], index=['a','b','C','D']) S2= PD. Series ([ten, +, +], index=['a','b','C','D'])PrintS1 +s2a11b22C33D44Dtype:int64Add the values corresponding to each index directly2. Index indexed array values are the same, in different order:S1 = PD. Series ([1, 2, 3, 4], index=['a','b','C','D']) S2= PD. Series ([ten, +,
I. Introduction of PANDAS1. The Python data analysis Library or pandas is a numpy-based tool that is created to resolve data analytics tasks. Pandas incorporates a number of libraries and a number of standard data models, providing the tools needed to efficiently manipulate large datasets. Pandas provides a number of f
"Original" 10 minutes to fix pandasThis article is a simple translation of "Ten Minutes to Pandas" on the official website of Pandas, the original is here. This article is a simple introduction to pandas, detailed introduction please refer to:Cookbook . As a rule, we will introduce the required packages in the following format:First, create the objectYou can view
This is a Pandas QuickStart tutorial that is primarily geared toward new users. This is mainly for those who like "Chanping" readers, interested readers can use the other tutorial articles to step by step more complex application knowledge.
First, let's say you've installed Anaconda, now start Anaconda and start learning the examples in this tutorial. The working interface is shown below-
Test the working environment for installation of
Use the pandas framework of Python to perform data tutorials in Excel files,
Introduction
The purpose of this article is to show you how to use pandas to execute some common Excel tasks. Some examples are trivial, but I think it is equally important to present these simple things with complex functions that you can find elsewhere. As an extra benefit, I will perform some fuzzy string matching to demonstrate
Introduction
The purpose of this article is to show you how to use pandas to perform some common Excel tasks. Some examples are trivial, but I think showing these simple things is just as important as the complex functions you can find elsewhere. As an extra benefit, I'm going to do some fuzzy string matching to show some little tricks, and show how pandas uses the complete Python module system to do somet
Some of the things that have recently looked at time series analysis are commonly used in the middle of a bag called pandas, so take time alone to learn.See Pandas official documentation http://pandas.pydata.org/pandas-docs/stable/index.htmland related Blogs http://www.cnblogs.com/chaosimple/p/4153083.htmlPandas introduction
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.