Detailed explanation of DataFrame of Pandas
Two dimensional data, Series container, with both row index and column index
1. Create DataFrame
1.1 create DataFrame through list
You need to specify data, index row and columns
Specify that data and index/columns are of type list or NP arange
df1 = pd.DataFrame(data=[[1, 2, 3], [11, 12, 13]], index=['r_1', 'r_2'], colum ...
Posted by troy_mccormick on Wed, 09 Mar 2022 13:10:02 +0100
Explain the 16 Pandas functions in detail to improve your "data cleaning" ability by 100 times!
Continue to share dry goods in Excel, MySQL and Python. Poke the official account link stamp. The beauty of data analysis and statistics Pay attention to this official account with a little bit of things. You can also obtain four original documents: Python automation office manual, Excel PivotTable complete manual, python basic query manual and ...
Posted by graham on Tue, 08 Mar 2022 01:41:54 +0100
[teach you how to download stock data from Tushare library and save it in hard disk]
preface
I've previously posted a film about using reptile technology from Article on obtaining stock data on NetEase Finance , the response is quite strong. However, that work can only be said to be an epitome of my early learning of reptiles and quantification. What I want to share with you now is very Dry goods. Basically, it can be sa ...
Posted by bobleny on Wed, 02 Mar 2022 16:31:57 +0100
Python data analysis | Pandas core operating functions
Author: Han Xinzi@ShowMeAITutorial address: http://www.showmeai.tech/tutorials/33Article address: http://www.showmeai.tech/article-detail/146Notice: All Rights Reserved. Please contact the platform and the author for reprint and indicate the sourceWhen we mention python data analysis, pandas will be used for operation in most cases. This is the ...
Posted by websiteguy on Fri, 25 Feb 2022 09:44:23 +0100
Two methods for Python to copy all sheet s in a table to another table [openpyxl / pandas] Practical Work Skills Sorting Series
Good morning, everyone. My name is Wu. If you think the article is well written, you can also call me Mr. Wu. Welcome to join me in the world of data analysis and learning!
Interested friends can follow me Data Analysis Column There are many good articles to share with you.
Front End Time encountered a problem while working - how to copy ...
Posted by ThinkGeekness on Mon, 07 Feb 2022 18:46:52 +0100
Pandas: deeply understand the data structure of pandas
brief introduction
This article will explain the basic data types Series and DataFrame in Pandas, and explain in detail the creation, indexing and other basic behaviors of these two types.
To use Pandas, you need to reference the following lib:
In [1]: import numpy as np
In [2]: import pandas as pd
Series
Series is a one-dimensional ...
Posted by AstroTeg on Tue, 01 Feb 2022 01:34:12 +0100
Pandas advanced tutorial: merging of Dataframe
brief introduction
Pandas provides many powerful functions of merging Series and Dataframe, which can facilitate data analysis. This article will explain in detail how to use pandas to merge Series and Dataframe.
Using concat
The most commonly used method is DF concat. Let's look at the following:
pd.concat(objs, axis=0, join='outer', i ...
Posted by Tsukasa on Sun, 30 Jan 2022 12:54:23 +0100
I reluctantly spent more than 20 minutes to meet the requirements of my sister, but
1, Narration (beginning of story)
The other day, my sister asked me to go out secretly and asked me to see a movie emmm.... It's nothing. Let's go. Hey, hey ~
Go??
I regretted going there. I found a park and sat watching movies on my mobile phone Feeding mosquitoes, sweating, watching boring movies, the key is that she doesn't let me idle, ...
Posted by Mchl on Sat, 29 Jan 2022 02:34:11 +0100
44_Pandas converts classified variables into dummy variables (get_dummies)
44_Pandas converts classified variables into dummy variables (get_dummies)
To convert categorical variables (categorical data, qualitative data) into virtual variables in pandas, use pandas get_ Dummies() function.
Data such as gender classified by string can be converted into 0 for men and 1 for women, and multi class features can be convert ...
Posted by dodgeqwe on Thu, 27 Jan 2022 18:42:21 +0100
Python data processing and analysis design a high return portfolio (return on investment and risk analysis) task 2: calculate the returns of different types and portfolios
Article catalog
1. Learning objectives
2. Operation explanation
3. Job results
1. Learning objectives
Understand simple and logarithmic returnsCalculate the return on investment for different stocks through Pandas and NumPyCalculate the return of the portfolio by linear summation
2. Operation explanation
Starting from this task, we wi ...
Posted by Tsukiyomi on Thu, 27 Jan 2022 09:27:56 +0100