how to import a csv file with python

create csv file python

# This action requires the 'csv' module
import csv

# The basic usage is to first define the rows of the csv file:
row_list = [["SN", "Name", "Contribution"],
             [1, "Linus Torvalds", "Linux Kernel"],
             [2, "Tim Berners-Lee", "World Wide Web"],
             [3, "Guido van Rossum", "Python Programming"]]

# And then use the following to create the csv file:
with open('protagonist.csv', 'w', newline='') as file:
    writer = csv.writer(file)
    writer.writerows(row_list)
# This will create a csv file in the current directory

Posted by: Guest on February-24-2020

Source

#Derive the id from the google drive shareable link. #For the file at hand the link is as below URL = 'https://drive.google.com/file/d/1m0mAGzpeMR0W-BDL5BtKrs0HOZsPIAbX/view?usp=sharing' path = 'https://drive.google.com/uc?export=download&id='+URL.split('/')[-2] #df = pd.read_pickle(path) df = pd.read_csv(path) df.head()

Code answers related to "how to import a csv file with python"

Code answers related to "Python"

Browse Popular Code Answers by Language

Answers for "how to import a csv file with python"

Code answers related to "how to import a csv file with python"

Code answers related to "Python"

Python Answers by Framework

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us