In this tutorial, you will learn how to create Pandas DataFrame in Python with multiple examples.
Example 1: Create Pandas DataFrame from a CSV in Python
In the following example, it will make the SFrame to CSV and then create the DataFrame from CSV:
sf = sframe.SFrame('yourFolder/big_data.gl/')
sf.save('yourFolder/big_data.csv', format='csv')
df = pandas.read_csv('yourFolder/big_data.csv.csv')
Example 2: Create DataFrame from HTML Data
Below example shows how to create Pandas DataFrame from the HTML data:
import pandas as pd
from bs4 import BeautifulSoup
html_doc = """
<h3>Ford</h3>
<h3>Toyota</h3>
<h3>Škoda</h3>
"""
soup = BeautifulSoup(html_doc, "html.parser")
car_names = soup.find_all("h3")
data = []
for name in car_names:
data.append({"Car Name": name.text})
df = pd.DataFrame(data)
print(df)
Output:
Car Name
0 Ford
1 Toyota
2 Škoda
Example 3: Creating a DataFrame by Merging 2 Dictionaries in Python
The below example will merge the two dictionaries and will create a DataFrame:
adBasicInfo = {} # 1.st dictionary
adOtherInfo = {} # 2.nd dictionary
adFullInfo = {} # Merged dictionary
adFullList = [] # List for appending merged dictionaries
# In each iteration merge dicts and append them in the list
for div in soup.findAll('a', {'class': 'result'}):
..some code...
adBasicInfo = {
u'adLink':adLink,
u'adThumbImg':...some code...,
u'adCounty':...some code...
}
adOtherInfo = getFullAdInfo(adLink) # Get complex dict
adFull = {**adBasicInfo,**adOtherInfo} # Merge dicts
adFullList.append(adFull) # Append dicts to list
# Save final version of list as pandas dataframe
adFullDF = pd.DataFrame(data=adFullList) # Save final list to dataframe
Example 4: Create Pandas DataFrame from Excel File
Below Python code will create the Pandas DataFrame from an Excel file:
import pandas as pd
data = pd.read_excel(r'YourExcelFilePath\Filename.xlsx')
df = pd.DataFrame(data, columns = ['Column1','Column2','Column3',...])
print (df)