Python не видит переменную table2

Question

Код следующий:

import pandas as pd

sum_row1 = table2.loc['row_1', 'D'] = table2.loc['row_1'].sum()
sum_row2 = table2.loc['row_1', 'D'] = table2.loc['row_2'].sum()
sum_row3 = table2.loc['row_1', 'D'] = table2.loc['row_3'].sum()
sum_row4 = table2.loc['row_1', 'D'] = table2.loc['row_4'].sum()

table2 = pd.DataFrame( data= [[11,21,10, sum_row1], [10, 30, 20, sum_row2], [11, 41, 30, sum_row3], [50, -100, 30, sum_row4] ] , index = ['row_1', 'row_2', 'row_3', 'row_4'], columns = ['B', 'D', 'E', 'sum'])

table2

Вывод:

---------------------------------------------------------------------------
NameError                                 Traceback (most recent call last)
c:\Users\*USER*\Documents\hw7.ipynb Cell 1' in <cell line: 3>()
      1 import pandas as pd
----> 3 sum_row1 = table2.loc['row_1', 'D'] = table2.loc['row_1'].sum()
      4 sum_row2 = table2.loc['row_1', 'D'] = table2.loc['row_2'].sum()
      5 sum_row3 = table2.loc['row_1', 'D'] = table2.loc['row_3'].sum()

NameError: name 'table2' is not defined

Есть идеи?

Изменил:

import pandas as pd


table2 = pd.DataFrame( data= [[11,21,10, sum_row1], [10, 30, 20, sum_row2], [11, 41, 30, sum_row3], [50, -100, 30, sum_row4] ] , index = ['row_1', 'row_2', 'row_3', 'row_4'], columns = ['B', 'D', 'E', 'sum'])

sum_row1 = table2.loc['row_1', 'D'] = table2.loc['row_1'].sum()
sum_row2 = table2.loc['row_1', 'D'] = table2.loc['row_2'].sum()
sum_row3 = table2.loc['row_1', 'D'] = table2.loc['row_3'].sum()
sum_row4 = table2.loc['row_1', 'D'] = table2.loc['row_4'].sum()


table2

Новый вывод:

NameError                                 Traceback (most recent call last)
c:\Users\*USER*\Documents\hw7.ipynb Cell 1' in <cell line: 3>()
      1 import pandas as pd
----> 3 table2 = pd.DataFrame( data= [[11,21,10, sum_row1], [10, 30, 20, sum_row2], [11, 41, 30, sum_row3], [50, -100, 30, sum_row4] ] , index = ['row_1', 'row_2', 'row_3', 'row_4'], columns = ['B', 'D', 'E', 'sum'])
      5 sum_row1 = table2.loc['row_1', 'D'] = table2.loc['row_1'].sum()
      6 sum_row2 = table2.loc['row_1', 'D'] = table2.loc['row_2'].sum()

NameError: name 'sum_row1' is not defined

Answer 1

Сначала нужно создать таблицу, а потом уже её заполнять. Столбец sum заполняется после, причём сразу во всех строках:

import pandas as pd

table2 = pd.DataFrame(data= [[11,21,10], 
                             [10, 30, 20], 
                             [11, 41, 30], 
                             [50, -100, 30]],
                      index = ['row_1', 'row_2', 'row_3', 'row_4'], 
                      columns = ['B', 'D', 'E'])

table2['sum'] = table2.sum(axis=1)
table2

БЛОГ НА HUSL

Python не видит переменную table2

Ответы (1 шт):