Экспортировать фрейм данных panda после группировки данных groupby() в электронную таблицу Google в лаборатории Google. ⇐ Python

[Anonymous]

Я использую Google Colaboratory для группировки очень больших данных (180 тыс. строк, 40 столбцов). Мне удается выполнить группировку, как показано ниже
df_1 = df.groupby(['CABANG','JENIS_PELAYARAN',pd.cut(df['GRT'], [0, 3500, 8000, 14000, 18000, 26000, 40000, 75000, 300000])])['PENDAPATAN_TUNDA'].sum().reset_index(name="sum")

Но когда я захотел экспортировать, мне не удалось. Ниже мой сценарий
gc = gspread.authorize(creds)
spreadsheet = gc.open_by_key('1a1aaaaaaaaaaaaaaaaa')
target = spreadsheet.get_worksheet_by_id(1174387715)
target.update(None,df_1)

Вот сообщение об ошибке
ValueError Traceback (most recent call last)

in ()
2
3 target = spreadsheet.get_worksheet_by_id(1174387715)
----> 4 target.update(None,df_1)

2 frames

/usr/local/lib/python3.10/dist-packages/pandas/core/generic.py in __nonzero__(self)
1517 @final
1518 def __nonzero__(self) -> NoReturn:
-> 1519 raise ValueError(
1520 f"The truth value of a {type(self).__name__} is ambiguous. "
1521 "Use a.empty, a.bool(), a.item(), a.any() or a.all()."

ValueError: The truth value of a DataFrame is ambiguous. Use a.empty, a.bool(), a.item(), a.any() or a.all().


Есть ли какие-то шаги, которые я пропустил? Я следил за другой похожей темой здесь, но мой вопрос здесь отличается.
Исходный заголовок фрейма данных в качестве словаря показан ниже
df.head(100).to_dict('series')

{'No': 1
2
3
4
5
..
95
96
97
98
99
Name: No, Length: 99, dtype: object,
'WLAYAH': 1 Wil 3
2 Wil 3
3 Wil 3
4 Wil 3
5 Wil 3
...
95 Wil 4
96 Wil 4
97 Wil 4
98 Wil 4
99 Wil 4
Name: WLAYAH, Length: 99, dtype: object,
'CABANG': 1 BMASIN
2 BMASIN
3 BMASIN
4 BMASIN
5 BMASIN
...
95 BMASIN
96 BMASIN
97 BMASIN
98 BMASIN
99 BMASIN
Name: CABANG, Length: 99, dtype: object,
'NAMA_KAPAL': 1 ISM 3024
2 ISM 3024
3 ISM 3024
4 ISM 3024
5 ISM 3024
...
95 ISM 3024
96 ISM 3024
97 ISM 3024
98 ISM 3024
99 ISM 3024
Name: NAMA_KAPAL, Length: 99, dtype: object,
'JENIS_KAPAL': 1 TONG
2 TONG
3 TONG
4 TONG
5 TONG
...
95 KONT
96 KONT
97 KONT
98 KONT
99 KONT
Name: JENIS_KAPAL, Length: 99, dtype: object,
'JENIS_PELAYARAN': 1 DNEGERI
2 DNEGERI
3 DNEGERI
4 DNEGERI
5 DNEGERI
...
95 LNEGERI
96 LNEGERI
97 LNEGERI
98 LNEGERI
99 LNEGERI
Name: JENIS_PELAYARAN, Length: 99, dtype: object,
'GRT': 1 3420
2 3420
3 3420
4 3106
5 3106
...
95 4356
96 4356
97 4356
98 5340
99 5340
Name: GRT, Length: 99, dtype: object,
'LOA': 1 91.44
2 91.44
3 91.44
4 87.74
5 87.74
...
95 100.58
96 100.58
97 100.58
98 111.25
99 111.25
Name: LOA, Length: 99, dtype: object,
'NAMA_AGEN': 1 SINAR BINTANG DUTA MULIA, PT
2 SINAR BINTANG DUTA MULIA, PT
3 SINAR BINTANG DUTA MULIA, PT
4 SARANA MARITIM SEJAHTERA PT
5 SARANA MARITIM SEJAHTERA PT
...
95 KARTIKA SAMUDRA
96 KARTIKA SAMUDRA
97 KARTIKA SAMUDRA
98 KARTIKA SAMUDRA
99 KARTIKA SAMUDRA
Name: NAMA_AGEN, Length: 99, dtype: object,
'SPK_PILOT': 1 IDBDJ-SPK.231
2 IDBDJ-SPK.231
3 IDBDJ-SPK.231
4 IDBDJ-SPK.231
5 IDBDJ-SPK.231
...
95 IDBDJ-SPK.231
96 IDBDJ-SPK.231
97 IDBDJ-SPK.231
98 IDBDJ-SPK.231
99 IDBDJ-SPK.231
Name: SPK_PILOT, Length: 99, dtype: object,
'NAMA_PANDU': 1 EDWINANDRA
2 SUGITTMOKO
3 SAMUERANNU
4 DODIKSMAIL
5 HABIBAJANY
...
95 DARYANTO
96 MAWAN BUDIANTO
97 DODIK ISMAIL
98 YOGI HARIYANTO
99 SAMUEL TAKKE RANNU
Name: NAMA_PANDU, Length: 99, dtype: object,
'PANDU_DARI': 1 AMBANG LUAR
2 REDE TRISAKTI
3 PULAU BAKUT
4 REDE TRISAKTI
5 PULAU BAKUT
...
95 AMBANG LUAR
96 PULAU BAKUT
97 REDE TRISAKTI
98 REDE TRISAKTI
99 PULAU BAKUT
Name: PANDU_DARI, Length: 99, dtype: object,
'TUG_1': 1
2
3
4
5
..
95
96
97
98
99
Name: TUG_1, Length: 99, dtype: object,
'TUG_2': 1
2
3
4
5
..
95
96
97
98
99
Name: TUG_2, Length: 99, dtype: object,
'TUG_3': 1
2
3
4
5
..
95
96
97
98
99
Name: TUG_3, Length: 99, dtype: object,
'TUG_4': 1
2
3
4
5
..
95
96
97
98
99
Name: TUG_4, Length: 99, dtype: object,
'TUG1_REALISASI': 1
2
3
4
5
..
95
96
97
98
99
Name: TUG1_REALISASI, Length: 99, dtype: object,
'TUG2_REALISASI': 1
2
3
4
5
..
95
96
97
98
99
Name: TUG2_REALISASI, Length: 99, dtype: object,
'TUG3_REALISASI': 1
2
3
4
5
..
95
96
97
98
99
Name: TUG3_REALISASI, Length: 99, dtype: object,
'TUG4_REALISASI': 1
2
3
4
5
..
95
96
97
98
99
Name: TUG4_REALISASI, Length: 99, dtype: object,
'USAGE_TUG1': 1
2
3
4
5
..
95
96
97
98
99
Name: USAGE_TUG1, Length: 99, dtype: object,
'USAGE_TUG2': 1
2
3
4
5
..
95
96
97
98
99
Name: USAGE_TUG2, Length: 99, dtype: object,
'USAGE_TUG3': 1
2
3
4
5
..
95
96
97
98
99
Name: USAGE_TUG3, Length: 99, dtype: object,
'USAGE_TUG4': 1
2
3
4
5
..
95
96
97
98
99
Name: USAGE_TUG4, Length: 99, dtype: object,
'FS_TIME_TUG1': 1
2
3
4
5
..
95
96
97
98
99
Name: FS_TIME_TUG1, Length: 99, dtype: object,
'FS_TIME_TUG2': 1
2
3
4
5
..
95
96
97
98
99
Name: FS_TIME_TUG2, Length: 99, dtype: object,
'FS_TIME_TUG3': 1
2
3
4
5
..
95
96
97
98
99
Name: FS_TIME_TUG3, Length: 99, dtype: object,
'FS_TIME_TUG4': 1
2
3
4
5
..
95
96
97
98
99
Name: FS_TIME_TUG4, Length: 99, dtype: object,
'FS_FUEL_USAGE_TUG1': 1
2
3
4
5
..
95
96
97
98
99
Name: FS_FUEL_USAGE_TUG1, Length: 99, dtype: object,
'FS_FUEL_USAGE_TUG2': 1
2
3
4
5
..
95
96
97
98
99
Name: FS_FUEL_USAGE_TUG2, Length: 99, dtype: object,
'FS_FUEL_USAGE_TUG3': 1
2
3
4
5
..
95
96
97
98
99
Name: FS_FUEL_USAGE_TUG3, Length: 99, dtype: object,
'FS_FUEL_USAGE_TUG4': 1
2
3
4
5
..
95
96
97
98
99
Name: FS_FUEL_USAGE_TUG4, Length: 99, dtype: object,
'JProduksi': 1
2
3
4
5
..
95
96
97
98
99
Name: JProduksi, Length: 99, dtype: object,
'ProdVar': 1
2
3
4
5
..
95
96
97
98
99
Name: ProdVar, Length: 99, dtype: object,
'Gol': 1 BMASIN1
2 BMASIN1
3 BMASIN1
4 BMASIN1
5 BMASIN1
...
95 BMASIN2
96 BMASIN2
97 BMASIN2
98 BMASIN2
99 BMASIN2
Name: Gol, Length: 99, dtype: object,
'FixT': 1
2
3
4
5
..
95
96
97
98
99
Name: FixT, Length: 99, dtype: object,
'VarT': 1
2
3
4
5
..
95
96
97
98
99
Name: VarT, Length: 99, dtype: object,
'PANDU_KE': 1 LAUT
2 AMBANG LUAR
3 REDE TRISAKTI
4 AMBANG LUAR
5 REDE TRISAKTI
...
95 PULAU BAKUT
96 REDE TRISAKTI
97 AMBANG LUAR
98 AMBANG LUAR
99 REDE TRISAKTI
Name: PANDU_KE, Length: 99, dtype: object,
'TIPE_LOKASI': 1 UMUM
2 UMUM
3 UMUM
4 UMUM
5 UMUM
...
95 UMUM
96 UMUM
97 UMUM
98 UMUM
99 UMUM
Name: TIPE_LOKASI, Length: 99, dtype: object,
'TIPE_GERAKAN': 1 KELUAR
2 PINDAH
3 MASUK
4 PINDAH
5 MASUK
...
95 KELUAR
96 MASUK
97 PINDAH
98 PINDAH
99 MASUK
Name: TIPE_GERAKAN, Length: 99, dtype: object,
'PENDAPATAN_PANDU': 1 512166
2 384125
3 512166
4 369887
5 493182
...
95 566598
96 566598
97 424949
98 466151
99 621534
Name: PENDAPATAN_PANDU, Length: 99, dtype: object,
'PENDAPATAN_TUNDA': 1 0
2 0
3 0
4 0
5 0
..
95 0
96 0
97 0
98 0
99 0
Name: PENDAPATAN_TUNDA, Length: 99, dtype: object,
'PENDAPATAN_FS': 1 0
2 0
3 0
4 0
5 0
..
95 0
96 0
97 0
98 0
99 0
Name: PENDAPATAN_FS, Length: 99, dtype: object,
'PENDAPATAN_TOTAL': 1 512166
2 384125
3 512166
4 369887
5 493182
...
95 566598
96 566598
97 424949
98 466151
99 621534
Name: PENDAPATAN_TOTAL, Length: 99, dtype: object}


Подробнее здесь: https://stackoverflow.com/questions/790 ... adsheet-in