Pandas为表创建DF

import pandas as pd

# 创建一个字典
data = {
    'Name': ['Alice', 'Bob', 'Charlie'],
    'Age': [25, 30, 35],
    'City': ['New York', 'Los Angeles', 'Chicago']
}

# 从字典创建 DataFrame
df = pd.DataFrame(data)

print(df)

      Name  Age         City
0    Alice   25     New York
1      Bob   30  Los Angeles
2  Charlie   35      Chicago

import pandas as pd

# 创建一个列表
data = [
    ['Alice', 25, 'New York'],
    ['Bob', 30, 'Los Angeles'],
    ['Charlie', 35, 'Chicago']
]

# 从列表创建 DataFrame，并指定列名
df = pd.DataFrame(data, columns=['Name', 'Age', 'City'])

print(df)

      Name  Age         City
0    Alice   25     New York
1      Bob   30  Los Angeles
2  Charlie   35      Chicago

import pandas as pd
import numpy as np

# 创建一个 NumPy 数组
data = np.array([
    ['Alice', 25, 'New York'],
    ['Bob', 30, 'Los Angeles'],
    ['Charlie', 35, 'Chicago']
])

# 从 NumPy 数组创建 DataFrame，并指定列名
df = pd.DataFrame(data, columns=['Name', 'Age', 'City'])

print(df)

      Name Age         City
0    Alice  25     New York
1      Bob  30  Los Angeles
2  Charlie  35      Chicago

Name,Age,City
Alice,25,New York
Bob,30,Los Angeles
Charlie,35,Chicago

import pandas as pd

# 从 CSV 文件创建 DataFrame
df = pd.read_csv('data.csv')

print(df)

      Name  Age         City
0    Alice   25     New York
1      Bob   30  Los Angeles
2  Charlie   35      Chicago

import pandas as pd

# 从 Excel 文件创建 DataFrame
df = pd.read_excel('data.xlsx')

print(df)

      Name  Age         City
0    Alice   25     New York
1      Bob   30  Los Angeles
2  Charlie   35      Chicago