DataFrames
¶https://vincentarelbundock.github.io/Rdatasets/datasets.html
pydataset
module specifically for accessing Rdatasets!cat accounts.csv
DataFrame
with the pandas function read_csv
names
argument specifies the DataFrame
’s column namesread_csv
assumes that the CSV file’s first row is a comma-delimited list of column namesimport pandas as pd
df = pd.read_csv('accounts.csv',
names=['account', 'name', 'balance'])
df
DataFrame
to a file using CSV format, call DataFrame
method to_csv
index=False
indicates that the row names (0
–4
at the left of the DataFrame
’s output above are not written to the filedf.to_csv('accounts_from_dataframe.csv', index=False)
!cat accounts_from_dataframe.csv
©1992–2020 by Pearson Education, Inc. All Rights Reserved. This content is based on Chapter 5 of the book Intro to Python for Computer Science and Data Science: Learning to Program with AI, Big Data and the Cloud.
DISCLAIMER: The authors and publisher of this book have used their best efforts in preparing the book. These efforts include the development, research, and testing of the theories and programs to determine their effectiveness. The authors and publisher make no warranty of any kind, expressed or implied, with regard to these programs or to the documentation contained in these books. The authors and publisher shall not be liable in any event for incidental or consequential damages in connection with, or arising out of, the furnishing, performance, or use of these programs.