Data Manipulation in Python
75 videos • 465 views • by Statistics Globe
How to manipulate data sets in the Python programming language.
1
Introduction to pandas Library in Python (Tutorial & Examples) | DataFrame Manipulation & Analysis
Statistics Globe
Download
2
Merge Two pandas DataFrames in Python (6 Examples) | Inner, Outer, Left & Right Join | Combine Data
Statistics Globe
Download
3
Insert Row at Specific Position of pandas DataFrame in Python (Example) | Add & Append New Data Line
Statistics Globe
Download
4
Combine pandas DataFrames with Different Column Names in Python | How to Apply the concat() Function
Statistics Globe
Download
5
Append Values to pandas DataFrame in Python (Example) | Add, Concat & Combine a List as a New Row
Statistics Globe
Download
6
Append Rows to pandas DataFrame in for Loop in Python (2 Examples) | Add to Existing & New Data Set
Statistics Globe
Download
7
Append Columns to pandas DataFrame in for Loop (Python Example) | Combine & Concatenate New Variable
Statistics Globe
Download
8
How to Create Subset of pandas DataFrame in Python (Example) | Subsetting Data by Logical Condition
Statistics Globe
Download
9
Convert String to Integer in pandas DataFrame Column in Python (Examples) | astype() & to_numeric()
Statistics Globe
Download
10
Compare Two pandas DataFrames in Python (Example) | Find Differences Row by Row | merge() Function
Statistics Globe
Download
11
Add Multiple Columns to pandas DataFrame in Python (Example) | Append, Merge & Join New Variables
Statistics Globe
Download
12
Combine pandas DataFrames with Same Column Names in Python (Example) | Append with concat() Function
Statistics Globe
Download
13
Add Column from Other pandas DataFrame in Python (Example) | Append & Join New Variable to Data Set
Statistics Globe
Download
14
Iterate Through Rows of pandas DataFrame (4 Examples) | for Loop Over Row | iterrows & itertuples
Statistics Globe
Download
15
Create New pandas DataFrame from Existing Data in Python (2 Examples) | Extract Specific Columns
Statistics Globe
Download
16
Convert NumPy Array to pandas DataFrame in Python (2 Examples) | Create from Matrix | Columns & Rows
Statistics Globe
Download
17
Convert True/False Boolean to 1/0 Dummy Integer in pandas DataFrame Column in Python (4 Examples)
Statistics Globe
Download
18
Merge Multiple pandas DataFrames in Python (2 Examples) | Combine Horizontally | Inner & Outer Join
Statistics Globe
Download
19
Slice pandas DataFrame by Index in Python (Example) | Split at Particular Row | How to Divide Data
Statistics Globe
Download
20
Merge pandas DataFrames based on Index in Python (2 Examples) | Add & Combine | Inner & Outer Join
Statistics Globe
Download
21
Convert pandas DataFrame to List in Python (3 Examples) | Extract Column & Row | Change All Elements
Statistics Globe
Download
22
Convert pandas DataFrame Index to List & NumPy Array in Python (2 Examples) | Extract Data Indices
Statistics Globe
Download
23
Calculate Median in Python (5 Examples) | List, DataFrame Column, Row & by Group | NumPy & pandas
Statistics Globe
Download
24
Drop Rows with Blank Values from pandas DataFrame in Python (3 Examples) | replace() & NaN Missings
Statistics Globe
Download
25
Convert pandas DataFrame to Dictionary in Python (Example) | Create dict Object | to_dict() Function
Statistics Globe
Download
26
How to Extract First & Last N Columns from pandas DataFrame in Python (2 Examples) | iloc Attribute
Statistics Globe
Download
27
Convert GroupBy Object Back to pandas DataFrame in Python (Example) | type & reset_index Functions
Statistics Globe
Download
28
Add Empty Column to pandas DataFrame in Python (2 Examples) | Attach String & NaN | float() Function
Statistics Globe
Download
29
Convert List to pandas DataFrame in Python (3 Examples) | Create Column & Row | Add as New Variable
Statistics Globe
Download
30
Append Multiple pandas DataFrames in Python (Example) | Concat, Add, Combine & Union Data Vertically
Statistics Globe
Download
31
Convert Dictionary to pandas DataFrame in Python (Example) | How to Create Row & Column from Dict
Statistics Globe
Download
32
Append pandas DataFrame in Python (4 Examples) | Concatenate & Combine Vertically | Stack DataFrames
Statistics Globe
Download
33
Create Subset of Columns of pandas DataFrame in Python (Example) | Extract & Print Selected Variable
Statistics Globe
Download
34
Replace NaN Values by Column Mean of pandas DataFrame in Python (Example) | fillna & mean Functions
Statistics Globe
Download
35
Merge List of pandas DataFrames in Python (Example) | Join & Combine | reduce() Function & functools
Statistics Globe
Download
36
Select Rows of pandas DataFrame by Condition in Python (4 Examples) | Range & Specific Set of Values
Statistics Globe
Download
37
Access Index of Last Element in pandas DataFrame in Python (4 Examples) | Extract First & Last Rows
Statistics Globe
Download
38
Sort pandas DataFrame by Date in Python (Example) | Order/Rearrange Rows | to_datetime & sort_values
Statistics Globe
Download
39
Count Rows by Group in pandas DataFrame in Python (Examples) | Number of Cases | groupby() & size()
Statistics Globe
Download
40
Sort Index of pandas DataFrame in Python (Example) | sort_index & reset_index Functions | Row Order
Statistics Globe
Download
41
Combine pandas DataFrames Vertically & Horizontally in Python (Example) | Join & Merge Side-by-Side
Statistics Globe
Download
42
Create Subset of Rows of pandas DataFrame in Python (2 Examples) | Logical Condition & Random Lines
Statistics Globe
Download
43
Create pandas DataFrame with Multiindex in Python (Example) | Set Multiple IDs | set_index Function
Statistics Globe
Download
44
Insert Column at Specific Position of pandas DataFrame in Python (2 Examples) | Middle or Beginning
Statistics Globe
Download
45
Drop pandas DataFrame Column by Index in Python (Example) | Remove & Delete One Or Multiple Columns
Statistics Globe
Download
46
Drop Duplicates from pandas DataFrame | How to Remove Repeated Row | All & Multiple Selected Columns
Statistics Globe
Download
47
Drop First & Last N Columns from pandas DataFrame in Python (2 Examples) | Select & Remove Variables
Statistics Globe
Download
48
Join pandas DataFrames based on Particular Column in Python (Example) | merge Function & on Argument
Statistics Globe
Download
49
Handling Index of pandas DataFrame in Python (Example) | How to Use Indices | Convert, Set & Merge
Statistics Globe
Download
50
Replace NaN by Empty String in pandas DataFrame in Python (Example) | Substitute by Blank Character
Statistics Globe
Download
51
Drop Infinite Values from pandas DataFrame in Python (Examples) | Replace inf by NaN | NumPy Library
Statistics Globe
Download
52
Convert pandas DataFrame to Series in Python (Example) | Create from Row | Apply squeeze() Function
Statistics Globe
Download
53
Create 1/0 Dummy Variable in pandas DataFrame in Python (2 Examples) | get_dummies & concat Function
Statistics Globe
Download
54
Select Columns of pandas DataFrame by Index in Python (2 Examples) | Extract One Or Multiple Columns
Statistics Globe
Download
55
Get Mode of NumPy Array in Python (2 Examples) | SciPy Library | How to Calculate by Column & Row
Statistics Globe
Download
56
Convert Index to Column of pandas DataFrame in Python (Example) | Add as Variable | index Attribute
Statistics Globe
Download
57
Rename Column of pandas DataFrame by Index in Python (Example) | Change Name | rename() Function
Statistics Globe
Download
58
Replace NaN with 0 in pandas DataFrame in Python (2 Examples) | Substitute by Zeros | All/One Column
Statistics Globe
Download
59
Change Order of Columns in pandas DataFrame in Python (2 Examples) | Sort Variables Alphabetically
Statistics Globe
Download
60
Set Index of pandas DataFrame in Python (Example) | How to Convert a Column Using set_index Function
Statistics Globe
Download
61
Convert Series to pandas DataFrame in Python (2 Examples) | Create Column | to_frame() & DataFrame()
Statistics Globe
Download
62
Convert pandas DataFrame to NumPy Array in Python (3 Examples) | Apply to_numpy() & values Attribute
Statistics Globe
Download
63
Replace Values of pandas DataFrame in Python (Example) | Substitute & Exchange by Index & Condition
Statistics Globe
Download
64
Rename Index of pandas DataFrame in Python (2 Examples) | Change Name | Convert Column to Indices
Statistics Globe
Download
65
Add Row to pandas DataFrame in Python (2 Examples) | Append List | How to Insert New Line in Middle
Statistics Globe
Download
66
Delete Rows of pandas DataFrame Conditionally in Python (Example) | Remove & Drop Multiple & One Row
Statistics Globe
Download
67
Rename Columns of pandas DataFrame in Python (2 Examples) | Change Variable Names | rename Function
Statistics Globe
Download
68
Reverse pandas DataFrame in Python (3 Examples) | Ordering Rows & Columns | reset_index() Function
Statistics Globe
Download
69
Sort pandas DataFrame by Column in Python (Example) | How to Order Rows | Apply sort_values Function
Statistics Globe
Download
70
Convert List from Character String to Integer (2 Examples) | map() Function vs. List Comprehension
Statistics Globe
Download
71
Combine Two Text Columns of pandas DataFrame in Python (Example) | Join, Merge & Append Variables
Statistics Globe
Download
72
Add Column to pandas DataFrame in Python (2 Examples) | Append List as Variable | assign() Function
Statistics Globe
Download
73
Select Multiple Columns of Pandas DataFrame in Python (4 Examples) | How to Extract & Get Variable
Statistics Globe
Download
74
Remove Rows with NaN from pandas DataFrame in Python (Example) | How to Drop & Delete Missing Data
Statistics Globe
Download
75
How to Convert a Factor to Numeric in R (Example Code) | Vector & Data Frame Column | Keep Numbers
Statistics Globe
Download