Tutorial by Examples

Table file with header, footer, row names, and index column: file: table.txt This is a header that discusses the table file to show space in a generic table file index name occupation 1 Alice Salesman 2 Bob Engineer 3 Charlie Janitor This is a footer becaus...

Data with header, separated by semicolons instead of commas file: table.csv index;name;occupation 1;Alice;Saleswoman 2;Bob;Engineer 3;Charlie;Janitor code: import pandas as pd pd.read_csv('table.csv', sep=';', index_col=0) output: name occupation index 1 Alice Sale...

Sometimes we need to collect data from google spreadsheets. We can use gspread and oauth2client libraries to collect data from google spreadsheets. Here is a example to collect data: Code: from __future__ import print_function import gspread from oauth2client.client import SignedJwtAssertionCred...