pd.read_csv()
pd.read_table()
','
';'
'|'
'\t'
in pandas
)sep
parameter in
read_csv()
; defaults to commapandas
with the read_fwf()
function; supply a list of column widths to the widths
parameterread_excel()
function in
pandas
pandas
API comprises the functions,
methods, etc. that you use in pandas
pandas
read_json()
functionhtml5lib
,
BeautifulSoup
, lxml
, scrapy
pandas
with the
read_html()
function (for tables)
pandas
url = 'https://www.espn.com/soccer/standings/_/league/ENG.1/season/2019'
epl = pd.read_html(url)
epl
We get back a list of data frame objects with team names (with clean-up required) in the first data frame and team performance in the second
np.where()
: If the specified condition is
True
, return the first supplied outcome; otherwise return
the second supplied outcomeconcat()
function in pandas:
stitches together data frames vertically (axis = 0
) or
horizontally (axis = 1
); relies on row/column indices
rather than key field value.to_xxx()
suite of methods allow you to write
pandas
data frames to a host of different formatsFor example: