将数据添加到不同列的扩展append_row

import pandas as pd

# 创建示例数据
data = {
    'id': [1, 2, 3],
    'name': ['John', 'Jane', 'Tom'],
    'age': [30, 25, 40]
}

df = pd.DataFrame(data)

# 新数据
new_data = {'id': 4, 'name': 'Alice', 'age': 22}

# 将新数据添加到DataFrame
df = df.append(new_data, ignore_index=True)

print(df)

   id   name  age
0   1   John   30
1   2   Jane   25
2   3    Tom   40
3   4  Alice   22

INSERT INTO users (id, name, age) VALUES (4, 'Alice', 22);

from pyspark.sql import SparkSession
from pyspark.sql import Row

# 创建SparkSession
spark = SparkSession.builder.appName("AppendRowExample").getOrCreate()

# 创建示例数据
data = [
    Row(id=1, name='John', age=30),
    Row(id=2, name='Jane', age=25),
    Row(id=3, name='Tom', age=40)
]

df = spark.createDataFrame(data)

# 新数据
new_data = [Row(id=4, name='Alice', age=22)]

# 将新数据添加到DataFrame
new_df = spark.createDataFrame(new_data)
df = df.union(new_df)

df.show()

+---+----+---+
| id|name|age|
+---+----+---+
|  1|John| 30|
|  2|Jane| 25|
|  3| Tom| 40|
|  4|Alice| 22|
+---+----+---+

# 创建示例数据
data <- data.frame(
  id = c(1, 2, 3),
  name = c('John', 'Jane', 'Tom'),
  age = c(30, 25, 40)
)

# 新数据
new_data <- data.frame(
  id = 4,
  name = 'Alice',
  age = 22
)

# 将新数据添加到DataFrame
data <- rbind(data, new_data)

print(data)

  id  name age
1  1  John  30
2  2  Jane  25
3  3   Tom  40
4  4 Alice  22

import gspread
from google.oauth2.service_account import Credentials

# 设置Google Sheets API凭据
scope = ["https://spreadsheets.google.com/feeds", "https://www.googleapis.com/auth/drive"]
creds = Credentials.from_service_account_file('path/to/your/credentials.json', scopes=scope)
client = gspread.authorize(creds)

# 打开Google Sheets
sheet = client.open('Your Google Sheet Name').sheet1

# 新数据
new_data = ['4', 'Alice', '22']

# 将新数据添加到Google Sheets
sheet.append_row(new_data)