Data Science code that appears all the time at workplace.
24,900 تومان
بیش از یک محصول به صورت دانلودی میخواهید؟ محصول را به سبد خرید اضافه کنید.
خرید دانلودی فوری
در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.
ویدئو معرفی این محصول
Learn exactly all the Programming (Python) skills that are needed all the time at workplace. Each video = 1 skill.
1 - Introduction
1 - Overview
2 - Full analysis
2 - analysis.zip
2 - Installing the necessary software
3 - Install Python
3 - Interacting with data in external sources
4 - How to read an xlsx file
4 - analysis.zip
4 - files-read-xlsx-files.rar
5 - How to skip reading some rows when reading a dataframe
5 - analysis.zip
5 - files-read-dataframe-skip-rows.rar
6 - How to read a specific sheet from an excel file into a dataframe
6 - analysis.zip
6 - files-sheetname.rar
7 - How to set the index of a dataframe upon reading it
7 - files-set-index.rar
8 - How to read specific columns from an excel file into a dataframe usecols
8 - files-usecols.rar
9 - How to read data from World Banks online database
9 - world-bank.rar
10 - How to send many dataframes into the same excel file xlsx in different sheets
10 - files-send-dataframes-to-excel.rar
11 - Sending a dataframe to a csv file
12 - How to hide warnings that Python produces And how to trigger manually warnings
13 - How to read only some rows from the topbottom of a dataframenrows skipfooter
13 - files-nrows-skipfooter.rar
14 - How to check if an Excel cell is empty
14 - files-check-if-cell-empty.rar
15 - How to see the version of the packages we have installed
15 - files-version-package.rar
4 - Index of a dataframe
16 - Columns and index resetindex setindex dropT
16 - files-reset-index-set-index-drop-T.rar
17 - How to change the index name of a dataframe
17 - files-change-index-name.rar
18 - How to find the row index & column index of any element of a dataframe
18 - analysis.zip
19 - How to enumerate the rows enumerate and use it in for loops
19 - enumerate.rar
5 - Lists
20 - How to sort the elements of a list
21 - How to remove some elements from a list at once
22 - How to create a list sublist that has some elements of another list
23 - Defining a list with numbers 1239 using list comprehension
24 - How to print the first 5 and the last 5 elements of a list
25 - How to include the elements of another list into a list extend versus append
26 - How to remove all occurrences of an element from a list
27 - Difference between pop and remove
6 - Dataframe HOWTOs
28 - How to return elements from a dataframe
28 - ds1.xlsx
29 - How to delete rowscolumns from a dataframe using iloc drop
29 - ds1.xlsx
30 - How to read the row column index and values dfvalues
31 - How to show the max number of rows and columns of a dataframe
31 - sensitive-data.xlsx
32 - How to create a copy of a dataframe
32 - sensitive-data.xlsx
33 - How to change specific values of a dataframe while leaving the rest unchanged
33 - data-selection.xlsx
34 - Create a new column and populate with elements of another column of a dataframe
35 - How to change the order of the columns of a dataframe
35 - showcase.xlsx
36 - How to create a new row in a dataframe and fill it with values from other rows
36 - showcase.xlsx
37 - How to fill a new column with values 123 nparange
37 - sensitive-data.xlsx
38 - How to use Pivot tables on Python
38 - initial-demand-set.xlsx
39 - How to rename rows and columns of a dataframe
40 - Going through every element with loc iloc and nested for loop
41 - Copypaste a row of a dataframe nprepeat
41 - initial-demand-set.xlsx
42 - How to sort the columns of a dataframe
43 - How to change the data type of a column of a dataframe
43 - ds1.xlsx
44 - How to prevent reading a row of a dataframe using iterrows continue and a list
45 - How to select many rows loc arange
46 - How to not allow duplicate values while inputting a new row in a dataframe
47 - How to return the value under other columns in the same row of a dataframe
48 - How to Iterate through the rows of a dataframe iteritems
49 - How to delete many rows from a dataframe at once
50 - How to correctly take a backup of a dataframe copy vs
7 - multi level column dataframes
51 - How to define a dataframe whose column index has many levels headers
51 - generationData.xlsx
52 - How to rename a column in a dataframe with many column index levels rename
52 - generationData.xlsx
53 - How to remove a level from a dataframe with many column levels
54 - Compressing all levels into 1 excel cell or showing them as is mergecells
54 - generationData.xlsx
55 - How to print dataframe merged cells as unmerged in excel startrow
56 - How to iterate through the rows of a multi level dataframe iteritems
56 - gens.xlsx
8 - Conditionals
57 - Inline if statement
9 - Logicals
58 - How to correctly write AND OR TRUE FALSE
59 - How to correctly write the NOT operator
60 - The De Morgans Law Many and or not statements
61 - Comparing objects of type int str float bool with each other
62 - Clarify difference between is
62 - Is-and.rar
10 - Tuples
63 - How to iterate through tuples Different types of forloops
11 - NaN values
64 - How to remove NaN values by deleting rows or columns
65 - Find if a dataframe has at least 1 missing value And find their exact location
66 - Using mincount to sum based when there are NaN values
67 - Manually place NaN values to dataframes
68 - How to sum rows of a dataframe by ignoring or considering NaN skipna replace
12 - Python Implementation of Excel Functions
69 - Model the Vlookup Excel function on Python map function
70 - Model the SUMIFS function on Python
71 - Model the AVERAGEIFS function on Python
13 - Strings
72 - How to evaluate string expressions using eval
73 - Removing trailing characters rstrip
74 - How to break a long sequence of characters in sets of 4 characters wrap
75 - How to select part of a string eg all string except last 3 characters
76 - Remove white space blanks from a string replace
77 - How to search for a subtext across a list of strings
78 - Selecting specific characters from a column using str
79 - How to replace characters or words from inside a string
14 - Datatypes
80 - Use name to find the datatype of an object
81 - Type conversions Int Float Str Bool
82 - Combining NOT with empty lists and strings
83 - How to check if the datatype of a variable is int float str NaN Nonetype
84 - Datatype of every element of a dataframe for loop dtypes astype
85 - what it means for x to be none empty list empty string
15 - Creating variables
86 - How to define variables using globals
16 - Sets
87 - Comparing the index of two dataframes using sets
17 - Dictionaries
88 - How to find the number of elements in a dictionary len
89 - How to convert a dictionary into a listset of keysvalues
90 - How to convert a dataframe to a dictionary todict and how to use it
91 - How to print the first 6 elements of a dictionary
92 - What it means to check if x is in dictionary
93 - Default dictionary part 1
94 - Default dictionary and lambdas
95 - How to convert a single value into a dictionary all keys are this value
96 - How to avoid errors when a key is not found in a dictionary command get
97 - How to have the same value while the keys differ
98 - How to unite two dictionaries double asterisk
99 - How to create a dataframe using a dictionary
18 - Numpy Arrays
100 - How to concatenate arrays
19 - Series
101 - How to define a series object that has a constant value
20 - Dates
102 - How to update a value in a DateTime index in a dataframe
102 - showcase.xlsx
103 - Using the Workalendar package for countryspecific Dates
104 - Use timedelta for time conversaions
21 - Functions
105 - Count how many times a function is called
106 - Another way Number of times a function is called through lists
22 - Bonus
107 - Discount-Coupons-october-2022.pdf
107 - Extras.html
107 - my personal website with great offers for you.zip
