Programming VIP

brief introduction We know that there are four types of numbers in Python, namely int, float, bool and complex. As a scientific computing NumPy, its data types are more abundant. Today, I will explain the data types in NumPy in detail. Data type in array NumPy is implemented in C language. We can compare the data types in the array in N ...

Chapter IV basis of pandas statistical analysis 4.1 read / write data from different data sources 4.1.1 read / write database data 1. Database data reading from sqlalchemy import create_engine from sqlalchemy.orm import sessionmaker engine = create_engine("mysql+pymysql://root:123456@127.0.0.1/testdb?charset=utf8mb4") session = sessionmake ...

This practical project is based on the dataset of Lending Club [dataset address: https://github.com/H-Freax/lendingclub_analyse/data/ ] This practical project is based on Colab environment brief introduction This practical project of data analysis is divided into two parts. The first part mainly introduces the Baseline method based on Lig ...

  Python is not only easier to use than other programming languages. In life, the technical scope of Python may not be as deep as that of other programming languages, but Python is definitely the most grounded. In theory, Python's affinity to the people can also be said to be the position of big brother. So what interesting little functions ...

In the statistical table, the statistics are usually accumulated in the current year, completed in the same period of the previous year (accumulated), completed in the current period (such as the current month) and completed in the last month, and the year-on-year and month on month analysis are carried out. The following example is shown in th ...

Official website: https://pandas.pydata.org/docs/reference/api/pandas.DataFrame.aggregate.html objective The main line of this article is to explore the basic usage of agg and the corresponding applicable scenarios, and finally make a simple exploration of the source code layer. 1. This paper introduces the parameters of agg and its demo 2. ...

Official website: https://pandas.pydata.org/docs/reference/api/pandas.DataFrame.resample.html objective This article is mainly written with the function of resample, the explanation of parameter configuration, and what parameters it can be used with. It will be explained as follows 1. What effect can resample achieve 2. What are the parame ...

Recently, I analyzed the vision data of a child and recorded it. Small partners who need data can download it. import numpy as np import pandas as pd import matplotlib.pyplot as plt import re import os import seaborn as sns import scipy.stats as ss plt.rcParams['font.family'] = ['SimHei'] plt.rcParams['axes.unicode_minus'] = False res_dir = ...

Xiaobai, who wants to switch to data analysis in the Internet industry, has a certain understanding of python through Buddhist Study in winter vacation. Record the first gadget. When I was brushing the cross forum, I suddenly saw a data analysis about the NBA. Because I also like playing very much, I immediately became interested. Because I d ...

In python, the following three modules are used to read, write and append data to excel tables: 1. wlrd reading data in excel 2. xlwt creates a new excel file, and then writes and saves the contents of this file. 3. xlutils reads an excel file, and then modifies or appends it. xlsx cannot be operated, only xls can be operated. 1, Reading ...