googleapis / googleapis/google-cloud-python

add `index=True` option to `to_gbq`

Offen
#14,481 0 Kommentare 0 Reaktionen 1 zugewiesene Person Beansprucht von @tswast Auf GitHub ansehen
api: bigquery type: feature request
Vorherrschende Sprache
Python
Sterne
5.4k
Forks
1.8k
Ø Merge
3 T. 4 Std.
Gemergte PRs (30 T.)
122

Beschreibung

**Is your feature request related to a problem? Please describe.**

I'd like to be able to control when the DataFrame Index/MultiIndex is included in the serialized BigQuery table.

**Describe the solution you'd like**

I'd like a boolean parameter `index=True` to enable writing the index column(s) to the BigQuery table. For backwards compatibility, we might need to keep this parameter `False` by default.

**Describe alternatives you've considered**

Folks can always call `DataFrame.reset_index(drop=False)` before uploading if they want this behavior, but I do think it'd be nice to be consistent with other I/O methods.

**Additional context**

* https://pandas.pydata.org/docs/reference/api/pandas.DataFrame.to_parquet.html (Has three options, where None is like True but serializes RangeIndex to metadata instead of as a column)
* https://pandas.pydata.org/docs/reference/api/pandas.DataFrame.to_csv.html (index=True by default. Also includes an index_label="string-here" parameter to override the index name)

Beitragsleitfaden

Beitragsleitfaden öffnen

Bewertung

Dieses Issue wurde noch nicht bewertet.

Neue Issues direkt in Ihr Postfach

Eine kurze Übersicht über anfängerfreundliche GitHub-Issues.