Видео

Дякую. Було цікаво.

ВММ навчаються на людських текстах? Чи не буде як в шаховій моделі - ШІ буде переймати собі людські помилки? Щоб виключити людський фактор, ВММ мають навчатися на текстах інших ВММ. Апдйт А, там далі є роз'яснення...

Я конечно в ахере - учусь на магистерской программе в Австрии - Cyber Security - семестр для иностранцев 1500 евро (для украинцев вообще сейчас бесплатно), если есть внж то 330евро\семестр, у вас 320к за два года.

Sub ParseAndCopyData() Dim sourceSheet As Worksheet Dim destSheet As Worksheet Dim lastRow As Long Dim i As Long Dim textArray() As String ' Define the source and destination sheets Set sourceSheet = ThisWorkbook.Sheets("Sheet1") ' Replace "Sheet1" with the name of your source sheet Set destSheet = ThisWorkbook.Sheets.Add(After:=Sheets(Sheets.Count)) destSheet.Name = "ParsedData" ' Find the last row in column B of the source sheet lastRow = sourceSheet.Cells(sourceSheet.Rows.Count, "B").End(xlUp).Row ' Loop through the cells in column B, starting from the 3rd row For i = 3 To lastRow ' Remove the first word and copy it to column A of the new sheet textArray = Split(sourceSheet.Cells(i, "B").Value, " ") If UBound(textArray) > 0 Then textArray(0) = "" End If destSheet.Cells(i - 2, "A").Value = Join(textArray, " ") ' Copy the text from the 6th to 9th character to column C of the new sheet destSheet.Cells(i - 2, "C").Value = Mid(sourceSheet.Cells(i, "C").Value, 6, 4) ' Copy the text from the 12th to 15th character to column D of the new sheet destSheet.Cells(i - 2, "D").Value = Mid(sourceSheet.Cells(i, "C").Value, 12, 4) ' Copy the text from the 20th to 26th character to column E of the new sheet destSheet.Cells(i - 2, "E").Value = Mid(sourceSheet.Cells(i, "C").Value, 20, 7) Next i End Sub

Sub ParseAndCopyData() Dim sourceSheet As Worksheet Dim destSheet As Worksheet Dim lastRow As Long Dim i As Long Dim text As String ' Define the source and destination sheets Set sourceSheet = ThisWorkbook.Sheets("Sheet1") ' Replace "Sheet1" with the name of your source sheet Set destSheet = ThisWorkbook.Sheets.Add(After:=Sheets(Sheets.Count)) destSheet.Name = "ParsedData" ' Find the last row in column C of the source sheet lastRow = sourceSheet.Cells(sourceSheet.Rows.Count, "C").End(xlUp).Row ' Loop through the cells in column C, starting from the 3rd row For i = 3 To lastRow ' Remove the first word and copy it to column A of the new sheet text = Trim(Mid(sourceSheet.Cells(i, "C").Value, InStr(sourceSheet.Cells(i, "C").Value, " ") + 1)) destSheet.Cells(i - 2, "A").Value = text ' Copy the text from the 6th to 9th character to column C of the new sheet destSheet.Cells(i - 2, "C").Value = Mid(sourceSheet.Cells(i, "C").Value, 6, 4) ' Copy the text from the 12th to 15th character to column D of the new sheet destSheet.Cells(i - 2, "D").Value = Mid(sourceSheet.Cells(i, "C").Value, 12, 4) ' Copy the text from the 20th to 26th character to column E of the new sheet destSheet.Cells(i - 2, "E").Value = Mid(sourceSheet.Cells(i, "C").Value, 20, 7) Next i End Sub

Sub RemoveFirstWordAndCopy() Dim sourceSheet As Worksheet Dim destSheet As Worksheet Dim lastRow As Long Dim i As Long Dim textArray() As String ' Define the source and destination sheets Set sourceSheet = ThisWorkbook.Sheets("Sheet1") ' Replace "Sheet1" with the name of your source sheet Set destSheet = ThisWorkbook.Sheets.Add(After:=Sheets(Sheets.Count)) destSheet.Name = "ModifiedData" ' Find the last row in column B of the source sheet lastRow = sourceSheet.Cells(sourceSheet.Rows.Count, "B").End(xlUp).Row ' Loop through the cells in column B, starting from the 3rd row For i = 3 To lastRow ' Split the text in the cell by space and remove the first word textArray = Split(sourceSheet.Cells(i, "B").Value, " ") If UBound(textArray) > 0 Then textArray(0) = "" End If ' Join the modified text back together and copy it to the new sheet's column A destSheet.Cells(i - 2, "A").Value = Join(textArray, " ") Next i End Sub

Дякую за корисний вебінар! Скажіть, будь ласка, які найпопулярніші причини через які студенти не закінчують повністю навчання? Чи це через завелике навантаження для когось і відповідно не закриття курсів чи втрата інтересу чи ще щось? Дякую

import java.io.FileWriter; import java.io.IOException; import java.lang.reflect.Array; import java.nio.file.Files; import java.nio.file.Paths; import java.nio.file.StandardOpenOption; import java.util.ArrayList; import java.util.Scanner; import java.util.regex.Matcher; import java.util.regex.Pattern; class Task{ private static int taskCounter = 0; // private int staticTaskCounter; private int taskID=100; private int priority; private String explanation; public String getExplanation(){ return explanation; } public int getTaskID(){ return taskID; } public int getTaskCounter(){ return taskCounter; } public Task(int priority, String explanation){ this.priority = priority; this.explanation = explanation; taskCounter = taskCounter+1; this.taskID = taskID + taskCounter; } @Override public String toString(){ return "Task ID="+this.taskID+", Priority="+this.priority+", "+this.getExplanation(); } } class ToDoList{ private ArrayList<Task> taskList = new ArrayList<Task>(); // public ToDoList(ArrayList<Task> taskList public ToDoList() throws IOException { // this.taskList = taskList; String newline = System.getProperty("line.separator"); int input = 6; while(input != 0){ Scanner scanner = new Scanner(System.in); Scanner scanner1 = new Scanner(System.in); System.out.println("ToDo List Operations:"+newline+ "1: List tasks."+newline+"2: Add a new task."+newline+"3: Delete a task."+newline+"4: Search tasks."+newline+"0: Exit."+newline+"Please enter your choice: "); input = scanner.nextInt(); if(input == 1){ listTasks(); } else if (input == 2) { System.out.println("Enter task priority (1: Low, 2: Medium, 3:High): "); int taskPriority = scanner.nextInt(); System.out.println("Enter task description: "); String taskDescription = scanner1.nextLine(); System.out.println("Task added to the Todo List."); addTask(new Task(taskPriority, taskDescription)); } else if (input == 3) { System.out.println("Delete a task: "); System.out.println("Enter a Task ID to be deleted: "); Scanner idscan = new Scanner(System.in); int idtobedeleted = idscan.nextInt(); removeTask(idtobedeleted); } else if (input == 4) { System.out.println("Enter the search keyword: "); Scanner searchWord = new Scanner(System.in); String searchedWord = searchWord.nextLine(); search(searchedWord); } else if(input == 0){ System.out.println("Bye."); // FileWriter myWriter = new FileWriter("recordBook2.txt"); // myWriter.write("alalade2"); // myWriter.close(); Files.write(Paths.get("recordBook.txt"), " something new".getBytes(), StandardOpenOption.APPEND); } } } void addTask(Task newTask){ taskList.add(newTask); } // how will it know taskID corresponds to taskID of the related instance void removeTask(int taskID){ boolean flag = true; for (Task task : taskList){ if (task.getTaskID() == taskID) { taskList.remove(task); flag = false; System.out.println("Task with ID: " +taskID+ " is removed."); break; } } if(flag){ System.out.println("Task with ID: "+taskID+" is not found in the Todo List"); } } void listTasks(){ System.out.println("There are "+this.taskList.size()+" tasks in the Todo List:"); for (Task task : taskList) { System.out.println(task.toString()); } } void search(String keyword) { int counter2 = 0; System.out.println("Search results for the keyword: "+keyword); for (Task task : taskList) { String theString = task.getExplanation(); Pattern pattern = Pattern.compile(keyword, Pattern.CASE_INSENSITIVE); Matcher matcher = pattern.matcher(theString); boolean matchFound = matcher.find(); if (matchFound) { System.out.println(task); counter2 = counter2 + 1; } } System.out.println("Found "+counter2+" tasks in the Todo List"); } } public class Main { public static void main(String[] args) throws IOException { ToDoList firstAttempt = new ToDoList(); } } //Some little problems: //1. After "Please enter your choice:" why input goes to the next line

нетворкінг сильна штука)

may i have access to your dataseet for this work

Great Video, if you can share the Github link

where can I get this paper?

Севіль молодчина

УКУ, Ви ламаєте стереотипи, відкриваєте нові шляхи і реалізовуєте мрії! Keep it up!

Сьогодні зіткнувся із Вашими роботами. Радий що в Україні є такі спеціалісти.

This video is priceless for me thanks a lot!

Очень даже ничего, крутое видео. Если вдруг поможет, для раскрутки канала использую Вибум, с промокодом E1600792569812 будет норм скидка

*4% OF MAMMALS ARE WILD + 4% OF ENERGY IS RENEWABLE* We burn soy, corn and palm oil in cars, also plastic and trees for electricity. The trees come from clearcuts to plant more soy corn and trees. This is called green energy. It’s fraud for green money called carbon credits. *Here’s what business as usual means:* Solar and wind power are 2% of total global energy use after 30 years trying . www.iea.org/data-and-statistics . By 2040 only 15% of global energy will be renewable . This is because electricity is only 20% of global energy use . By weight only 4% of mammals are wild ( humans & livestock = 96% ) . Emissions went up 50% in 30 yrs , up 30% in 15 years . C02 will be 500 ppm by 2040 and 600 ppm by 2050 = 2X safe limit of 300 ppm . Renewables will be only 20% of global energy by 2050, even with new solar tech - thanks to AC demand and cryptos, chargers etc. Dams and bio-energy are ecological shitholes. You can’t burn forests for electricity to save us from the climate. To get 30% of energy from algae would take a country the size of Argentina. Soy and corn are gene modded to survive the poisons that kill birds, bugs, fish, frogs & plants Soy and corn are treated with petrochemicals and nano particles for market Soy and corn are wrapped in gender bending containers for shipping and storage, then we eat it - get sick - and buy medicine from the same people. There will never be a 100% green energy vegan world, ever. Some ideas are so stupid, only intellectuals believe them. Academic circle jerk asphyxia is the leading cause of male extinction. See: 4% of global energy is renewable - YT, WSJ, BP 2019 lokisrevengeblog.files.wordpress.com/2019/10/renewable-2030.png 4 global climate treaties failed in 30 years - Canadian Government 2018 lokisrevengeblog.files.wordpress.com/2019/07/canada-emissions-record.jpg 15% of global energy will be renewable by 2040 - YT WSJ BP 2019 lokisrevengeblog.files.wordpress.com/2019/10/renewable-2030-02.png 15% of global energy will be renewable by 2040 - CNBC IEA 2018 lokisrevengeblog.files.wordpress.com/2019/12/2040-energy.png “To meet 20% of all global energy by 2050, the solar industry would need to install 300 to 500 GW annually over the next 30 years. Current global PV module manufacturing is 100 GW per year.” www.solarpowerworldonline.com/2020/02/perovskite-solar-cells-hero-villain-or-just-plain-fantasy/ Even without increased AC, crypto and charger demands, renewables are unfit for purpose on a global scale. 5% or even 10% per decade won’t do. 50 Reasons why wind power can not replace fossil fuels energyskeptic.com/2019/wind/ Global scale new solar wind tech will take decades to do. They still chug out solar panels the old fashioned way, and won’t stop until they have to. It’s the same with giant offshore epoxy wind blades. They’re worth too many millions to shut down just because it’s wrong.

Awesome. I proud your achievements.

Hello views join me to appreciate Dr. Oseremen for the great work he did for me, that have be my happiest day in my life this true life story you should pickup a point. I have been diagnose of herpes virus for eight [8] years,I’ve lost all hope and that there is no cure and I have been taken medicine to sustain myself till I got to know about Dr. Oseremen through a friend who he cured of herpes. I contacted him and he sent me his herbal medicine which I took as he directed me to do for 21 days and after taking his herbs, I went to the hospital and I was confirmed herpes Negative after years of pains and suffering , it is indeed a miracle, Dr. Oseremenis a great man, I have heard so much about how he has help lot of people, if you have any issue you can contact him for help.via email him on. Dr.oseremenvadi@gmail.com you can as well call his mobile number or add him on whatsapp +2349056394313

Спасибо за лекцию, можно ли как-то получить конспект?

А слайды есть где-то выложенные?)

Дякую! Було дуже інформативно послухати взагалі про data science, а також про можливості саме самостійного навчання.

дякую за запис!

Thanks for my mom for support!

Було б добре тут дати лінк на презентацію.

Дякую, якраз думаю куди далі з QA Automation іти.

"Fix the cause, not the symptom." author ~ "Steve Maguire"

Congratulations for your work, Team 1!

Добрый день! Дайте, пожалуйста, корректную ссылку на open data science

Не хватает краткого содержания в описании

fixing for mirror video - deturl.com/mirror-flip.asp?v=WisiCT0rAbg

Why the image is mirrored?

Якщо УКУ зробить курс з Data Science онлайн, то це змусить багатьх політиків переглянути позицію до системи освіти в Україні, адже УКУ почне більше переманювати студентів до себе з інших ВНЗ країни. І державній системі освіти стане важко конкурувати з приватною чи онлайновою

Сподіваюсь ви зробите цікаву програму, на якій студенти не сплять :)