در حال حاضر محصولی در سبد خرید شما وجود ندارد.

پنل کاربری

رمز خود را فراموش کرده اید؟ اگر اولین بار است از سایت جدید استفاده میکنید باید پسورد خود را ریست نمایید.
دسته بندی
دسته بندی

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