Programmer Think

Anyone who has used SAP's voucher batch entry template (Excel file) knows that a voucher consists of header and multiple line items, which is a typical scenario about the association of two excel tables. There is a problem here: when we need to enter multiple vouchers at one time, how to associate the header of each voucher with the line item? ...

Note: this blog is based on Python 3, matplotlib 3.5.1, numpy 1.22.0 preface Visual operation is widely used in data analysis and machine learning. It can help people observe outliers or required data conversion effects more intuitively; As a desktop drawing package of python, matplotlib can generate publishing quality charts; The work ...

Hands on data analysis Chapter 2: data cleaning and feature processing import numpy as np import pandas as pd #Load data train csv df = pd.read.csv('train.csv') df.head(10) Brief description of data cleaning The data we get is usually unclean. The so-called unclean means that there are missing values and some abnormal points in the data, w ...

Tianchi competition -- visual analysis of user emotion catalogue Tianchi competition -- visual analysis of user emotion preface 1, Read the data, check the basic situation and preprocess the data Import related Library Read data, basic analysis data Null value processing, data mapping Word segmentation analysis of comments 2, Word ...

Welcome to pay attention Python series , continuously updating Welcome to pay attention Python series , continuously updating API Description: 1. Create a Word routine with a title Create Word with title Create a blank document through Document() and call add_ The heading method creates a heading. # Import library from docx impor ...

Chapter II Section I data loading and preliminary observation 1.1 loading data 1.1.1 task 1: import numpy and pandas import numpy as np import pandas as pd 1.1.2 task 2: load data (1) Load data using relative paths #Import relative path data df=pd.read_csv('train.csv') (2) Load data using absolute path #Absolute path import data ...

This article mainly introduces the detailed explanation of Python function definition and parameter transmission methods (4 kinds). The example code in this article is very detailed, which has certain reference and learning value for everyone's study or work. Friends in need, let's learn together with Xiaobian 1, Elementary knowledge of functi ...

Data grouping and traversal In this chapter, the demo data sets we use are: import pandas as pd dic = {'ID':[1001,1002,1003,1004,1005,1006,1007,1008,1009,1010,1011], 'name':['Zhang San','Li Si','Wang Wu','Zhao Liu','Sun Qi','Zhou Ba','Wu Jiu','Zheng Shi','Zhang San','Wang Wu','Zheng Shi'], 'age':[18,19,20,20,22,22,18,19,19,23,20], ...

The daily question selects the frequently asked interview questions, summarizes them into a column, and uses spare time to escort the career. It is recommended that you think and answer the questions independently. Hello, in the process of data job recruitment, we often investigate the SQL ability of job seekers. Here are three frequently test ...

What we need to do in this chapter is to use data. The purpose of data analysis is to use our data and combine my business to get some results we need to know. Then the first step of analysis is modeling, building a prediction model or other models; After we get to the results of this model, we need to analyze whether my model is reliable enoug ...