Articles → Pandas → Write In CSV File Using To_Csv Function In Pandas
Write In CSV File Using To_Csv Function In Pandas
Example
import pandas as pd
# Create a dictionary
dict = {
"company": ["Google", "Microsoft", "Apple", "Google", "Microsoft", "Apple"],
"year": [2017, 2017, 2017, 2018, 2018, 2018],
"Profit": [20000, 40000, 60000, 80000, 70000, 50000],
}
# Create a dataframe
df = pd.DataFrame(dict, index=[0, 1, 2, 3, 4, 5])
df.to_csv("c:\\temp\\B.csv")
Output
Click to Enlarge
Index = False Attribute
import pandas as pd
# Create a dictionary
dict = {
"company": ["Google", "Microsoft", "Apple", "Google", "Microsoft", "Apple"],
"year": [2017, 2017, 2017, 2018, 2018, 2018],
"Profit": [20000, 40000, 60000, 80000, 70000, 50000],
}
# Create a dataframe
df = pd.DataFrame(dict, index=[0, 1, 2, 3, 4, 5])
df.to_csv("c:\\temp\\B.csv", index=False)
Click to Enlarge