How to create a DataFrame in Python?

There are several ways to create a DataFrame, here are some common methods:

1. Creating a DataFrame from a list or an array.

import pandas as pd

data = [['Alice', 25], ['Bob', 30], ['Charlie', 35]]
df = pd.DataFrame(data, columns=['Name', 'Age'])

1. Create a DataFrame from a dictionary:

import pandas as pd

data = {'Name': ['Alice', 'Bob', 'Charlie'], 'Age': [25, 30, 35]}
df = pd.DataFrame(data)

1. Create a DataFrame from a CSV file.

import pandas as pd

df = pd.read_csv('data.csv')

1. Create a DataFrame from an Excel file.

import pandas as pd

df = pd.read_excel('data.xlsx')

1. Create a DataFrame from a query result in a SQL database.

import pandas as pd
import sqlite3

conn = sqlite3.connect('database.db')
query = 'SELECT * FROM table_name'
df = pd.read_sql(query, conn)

These are just some examples of methods for creating DataFrames; depending on the specific data source and requirements, there may be more methods available for creating DataFrames.