Do you know the multiples ways to scrape data and information from the web? How to get tables from HTML pages?
In this tutorial of statistics and data science with Python we will discuss the extraction of tables to Data Frames with python using Pandas.
* How to extract / scraping information and data from the web
* Capture the desired table / paragraph from object
* Using functions to filter data
* Select columns and tables
#Python #Pandas #WebScraping #machinelearning
Any comments or suggestions are welcome.
Contact: inforvstats@gmail.com
Mi canal de estadistica en español
https://www.youtube.com/channel/UCe4UCHmQu92O03Z1fgzUXmQ
# Classification with XGB and python: https://youtu.be/ptFRggaTCXs
# Hierarchical clustering with python Video Chapter 1: https://youtu.be/m_zaJakEUm4
## Clustering in python
https://youtu.be/m_zaJakEUm4
## clustering in R
https://youtu.be/qrm8igxwHOQ
Filter and select dataframes: https://youtu.be/TOP1PJ_Ub2c
- Applying the function filter for dataframes
- Using iloc and loc for filtering
- Selecting by observations, column or multiple columns, by indices
- Utilizing the function where, Condition or conditions for filtering data
Set and reset index in DataFrames: https://youtu.be/IYNCpPLq1b8
- Create dataframes with indices and understand how index works
- New observations with new index
- Set index to a dataframe
- Using and applying reset_index
- Two columns as new indices
- Using iloc and loc with index
Part 1: Definition and creation: https://youtu.be/RadSHvFiwXM
- What is a Data Frame?
- EXCEL table or Sql Table?
- DataFrame constructor and its options
- Using pandas as pd
- Defining a data frame with lists, dictionary, tuples and lists
- Defining data frames with series
Part 2: Exploring and extracting information: https://youtu.be/Ow7FnISHDOo
- How to create a dataframe with dictionaries
- Using the function describe to obtain a summary
- utilize the function shape to obtaning number of rows and columns
- What is index and how to get the indices
- Extract different values from the dataset
- What is the function head? and what is tail? size ?
- First observations in a data frame
- How to access to columns using names and brackets [ ]
- What is data type? dtype?
Part 3: https://youtu.be/SLvROGyiPoQ
- Defining a dataframe and understanding its indices
- How to use iloc an loc
- Row names, column names and index number
- How to use at and iat
- Using [ ], and multiple observations
- Defining a dataframe with indices names
Part 4: https://youtu.be/JChdh13-RGo
- Create and define new columns
- Define and build dataframes from scratch
- Using assign for inserting new rows / observations
- Concatenate two dataframes into a new one
- Utilize loc and iloc
- Understanding index
** More videos and tutorials ***
- Data types, tuples and object in Python: https://youtu.be/2U8fInYd6lc
- Sequence and range with python: https://youtu.be/hmOBfqKaC5g
- List in Python: https://youtu.be/m9ln3Y4x6Lk
- Creating dictionaries in python: https://youtu.be/C6Y5GvV8nOU
- Mapping with dictionaries in python: https://youtu.be/YC5w4kRoYkI
- Vectors and numpy: https://youtu.be/YYGPhKYDDS0
Any comments or suggestions are welcome.
Contact: inforvstats@gmail.com
Mi canal en español:
https://www.youtube.com/channel/UCe4UCHmQu92O03Z1fgzUXmQ
# Statistical data analysis
# Linear algebra
# mathematic math beginner
# tutorial for starters python basics
# statistics for beginners
## Statistics and data science Course in R
https://www.youtube.com/playlist?list=PLgedSm0esItUtAwceJ0jC40GwxvTQRCRK