Scraping and Analysing YouTube Trending Videos for BI

Analysis of structured data has seen tremendous success in the past. However, large scale of an unstructured data have been analysed in the form of video format remains a challenging area. YouTube, a Google company, has over a billion users and it used to generate billions of views. Since YouTube data is getting created in a very huge amount with a lot of views and with an equally great speed, there is a huge demand to store the data, process the data and carefully study the data in this large amount of it usable. The project utilizes the YouTube Data API (Application Programming Interface) which allows the applications or websites to incorporate functions in which they are used by YouTube application to fetch and view the information. The Google Developers Console which is used to generate an unique access key which is further required to fetch the data from YouTube public channel. Process the data and finally data stored in AWS. This project extracts the meaningful output of which can be used by the management for analysis, these methodologies helpful for business intelligence.

Methodology for Taking into Account the Morphological Features of River Channels and Dankfull Discharges when Establishing the Planned Position of the Watercourse Coastlines

Based on the analysis of a large volume of data of hydrological regime observations, as well as of field hydro/morphological studies, it is shown that, due to the ambiguity of the definitions of certain provisions of the Water Code of the Russian Federation, related to the establishment of the planned position of the coastline (boundary) of the watercourse, in some cases the implementation of these provisions is practically impracticable. To take into account the morphological features of river channels in determining the boundary of a watercourse, the bankfull discharge is illustrated, the use of the concept of “coastal edge” is justified, and recommendations are given on methods for its establishment for each of the hydro/morphological types of river channels and types of channel process. Recommendations are formulated for determining the frequency of updating the position of the coastline in areas with coastal deformations.

Features of the hydrological regime and channel processes on the Iltsya river (Chornyy Cheremosh basin)

This publication analyzes the features of the hydrological regime and channel processes of the Iltsya River, based on regular observations and during the expedition trip in June 2019.The schemes of basin distribution and geomorphological zoning of the studied object, curves of connection of water consumption and levels Q = f (H), graphs of the course of maximum, average and minimum water levels, and also cross sections on key sites are presented in the work. Conditions of channel formation of natural watercourses are a complex and multilateral process which is closely connected with natural features of the territory of their basin.The main factors of the natural channel process are the geological structure of the area, sediment flow and grain size. These factors are key, however, the processes of channel formation are also influenced by additional factors that are temporary or local in nature. At the same time, we should not forget about the influence of the anthropogenic factor, the results of which for the basins of small rivers can sometimes even dominate for some time over the main ones mentioned above. All these factors not only affect the channel process, but also difficult to interact with each other. The geological structure, including the lithology of rocks, as well as the relief of the territory, have a direct impact on the shape of the valley, the longitudinal profile, the composition of channel-forming sediments, and hence the stability of the channel. Water runoff is the main active factor that depends on the hydrological regime of the river and determines its water content and size. The nature of the sediments and their regime is a factor that determines the rate and direction of vertical and horizontal deformations of the channel. The object of our study - is the river Iltsya, a small left tributary of the ChornyyCheremosh, which is characterized by specific geological conditions, and therefore significantly different from other small rivers in the region, including neighboring tributaries of the main river (ChornyyCheremosh). The second feature of the studied river is that the lower part of its basin is located within the Vorokhta-Putilsky ancient terraced lowlands, while the sources are formed within the Pokutsko-Bukovynian Carpathians, which in turn determines a certain specificity in the formation of its channel. This geological and geomorphological feature of the Iltsya river basin distinguishes it among numerous similar small rivers of this region of the Ukrainian Carpathians. Summarizing all the above, we have made some conclusions, the basin of the river Iltsya is currently little studied, both in terms of hydrological regime, channel processes and geomorphological studies, although in fact it is quite interesting and not typical of project, which raises many questions that require more detailed study. The presence of a long series of observations, allows us to identify general tendencies to the gradual incision of the channel in the area of the hydropost, although with little intensity. Visual inspection showed more manifestations of horizontal transformations associated with the movement of alluvial ridges and erosion of the shores. The greatest feature of the Iltsya river basin is the polymorphic formation of its channel system, because within the Vorokhta-Putil lowlands the river Iltsya and VelykyiRosysh occupy a wide valley of the ancient pliocene river, and this nuance has the greatest influence on the nature of riverbeds within its limits.

Simultaneous Refinement of Primary Si and Modification of Eutectic Si in A390 Alloy Assisting by Sr-Modifier and Serpentine Pouring Channel Process

In this study, A390 alloy was prepared using the combined process of a water-cooled copper serpentine pouring channel (SPC) and strontium (Sr) modifier, in order to simultaneously refine primary silicon (Si) and modify eutectic silicon (Si). The nucleation and growth mechanisms of the Si phase were discussed by morphology analysis and non-isothermal analytical kinetics. The results indicate that the size of primary Si is refined to 25.2–28.5 µm and the morphology of eutectic Si is modified from acicular into fibrous. The serpentine pouring channel process stimulates primary Si nucleation due to chilling effect and has no influence on eutectic Si nucleation. Impacts of Sr-modifier on primary and eutectic Si are similar, including three aspects: (1) poisoning of the nucleation site; (2) decreasing the interface energy between Si phase and liquid; (3) raising the activation energy for diffusion across solid-liquid interface. The content of Sr determines which one of the three aspects mentioned above is the dominant factor to promote or restrain the nucleation and growth of the primary and eutectic Si in hypereutectic Al-Si alloy.