python多个条件循环,python中具有多个条件的循环

如前所述，考虑使用Pandas，Python强大的数据分析包，您甚至可以在其中将列表导入数据框或从csv或sql表导入。在

(我将更多的数据点添加到示例中进行演示。注意宏碁和Cemex按交易计数)：import pandas as pd

transaction = ['BUY','SELL', 'BUY', 'BUY', 'BUY', 'SELL']

company = ['Acer', 'Cemex', 'Acer', 'Apple', 'Cemex', 'GE']

value = [[0.5344, 2.23423], [5.43534, 4.3342543],

[5.4387874, 4.3342543], [2.9313534, 4.3342543],

[4.431224, 4.3342543], [6.4778734, 4.3342543]]

# DEFINE DATA FRAME

df = pd.DataFrame({'transaction':transaction,

'company':company,

'value1':[value[0][0],value[1][0],value[2][0],

value[3][0],value[4][0],value[5][0]],

'value2':[value[0][1],value[1][1],value[2][1],

value[3][1],value[4][1],value[5][1]]})

print(df)

# company transaction value1 value2

# 0 Acer BUY 0.534400 2.234230

# 1 Cemex SELL 5.435340 4.334254

# 2 Acer BUY 5.438787 4.334254

# 3 Apple BUY 2.931353 4.334254

# 4 Cemex BUY 4.431224 4.334254

# 5 GE SELL 6.477873 4.334254

print(df.groupby(['company', 'transaction']).count())

# value1 value2

# company transaction

# Acer BUY 2 2

# Apple BUY 1 1

# Cemex BUY 1 1

# SELL 1 1

# GE SELL 1 1