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