pandas.DataFrame method to create new columns and assign values based on conditions-Python Tutorial-php.cn

pandas.DataFrame method to create new columns and assign values based on conditions

不言

Release： 2018-04-09 14:53:53

Original

13242 people have browsed it

Let me share with you a pandas.DataFrame method of creating new columns and assigning values based on conditions. It has certain reference value and I hope it will be helpful to everyone.

The example is as follows:

import numpy as np
import pandas as pd

data = {&#39;city&#39;: [&#39;Beijing&#39;, &#39;Shanghai&#39;, &#39;Guangzhou&#39;, &#39;Shenzhen&#39;, &#39;Hangzhou&#39;, &#39;Chongqing&#39;],
    &#39;year&#39;: [2016,2016,2015,2017,2016, 2016],
    &#39;population&#39;: [2100, 2300, 1000, 700, 500, 500]}
frame = pd.DataFrame(data, columns = [&#39;year&#39;, &#39;city&#39;, &#39;population&#39;, &#39;debt&#39;])

# 使用apply函数, 如果city字段包含&#39;ing&#39;关键词，则&#39;判断&#39;这一列赋值为1,否则为0
frame[&#39;panduan&#39;] = frame.city.apply(lambda x: 1 if &#39;ing&#39; in x else 0)
print(frame)

Copy after login

Related recommendations:

Basic operation method of Python data analysis library pandas_python

Python solves the problem of pandas processing missing values as empty strings_python

The above is the detailed content of pandas.DataFrame method to create new columns and assign values based on conditions. For more information, please follow other related articles on the PHP Chinese website!

pandas.DataFrame method to create new columns and assign values ​​based on conditions

pandas.DataFrame method to create new columns and assign values based on conditions