How split my dataset?

01 June 2022 1 2K Report

Hi,

I have a question for data analysis, I have a column in my dataset including locations "Brussels", "Flanders","Wallonia". I have postal codes too and I want to split the Flanders and Wallonia based on the main cities and other cities. How can I in R or excel split data then I want to have Brussels, the main cities of Wallonia and Flanders, and other cities of Wallonia and Flanders instead of "Brussels", "Flanders", and "Wallonia.

thank you

Proloy Barua

Following links maybe useful especially filter function in R dplyr::filter()

https://www.statology.org/r-split-data-frame/

https://www.statology.org/subset-data-frame-in-r/

https://stackoverflow.com/questions/57948109/is-there-a-way-in-r-to-filter-and-split-a-dataframe-into-new-dataframes

Badges
Science topic

More Sam H.Bahreini's questions See All

What is the correct way of calculating CO2 from private transportation and what is correct emission factor?

Hi, I have a question about emission factors for passenger cars based on the EMEP/EEA air pollutant emission inventory guidebook 2023, in the link that I used to calculate the CO2 emission per...

04 July 2024 1,766 2 View

Lentiviral Transduction Issues?

Hi there, I am attempting to transduce cells with the TLCV2 plasmid containing our sgRNA of interest. My transfection of the HEK 293T cells seems to yield positive results as the EGFP is clearly...

06 June 2024 2,131 1 View

Gerber file extraction in CST?

I have a feed alone as one of the layer. When i try to extract that, I get the folloing error. Kindly help me , how to resolve the issue and extract the gerber file

29 February 2024 3,772 2 View

What is the best way to photobleach eGFP?

Dear all, I'm doing cell culture with lentiviruses including eGFP. While this is a very useful way to check transduction efficiency, it does take up a channel with subsequent immunofluorescence...

20 February 2024 1,660 2 View

Common scenario, experimental vignette and response to a question?

I want respondents to see a scenario (common scenario that contain uncivilized behavior of consumers) and then provide vignette carrying a message (manipulative variables-Proscriptive Vs...

04 February 2024 4,952 0 View

What is the best far-red dye for fixed cells?

Dear all, We have a Olympus FV1200 confocal microscope with 405, 473, 559, and 635 lasers. I'm looking for a nuclear dye (fixed cells) in the far red range, does anyone have any recommendations...

23 January 2024 6,491 4 View

Please advise theoretical aspect of business management in construction ?

22 January 2024 567 3 View

How to add survey data to a map in ArcMap GIS?

Hello, I have data that I collected from a survey that contains qualitative data (ordinal/nominal) and includes the participant’s residential neighborhood, 800 participants distributed over 50...

24 December 2023 8,001 3 View

What is the best way to work through push back on inclusion from general education teachers?

Based on what I've learned from my MSE program, I'm working on further inclusion of my self contained students past the sole expectation of socialization and friendship building. I have my...

04 December 2023 2,622 7 View

What is this growth in my cells?

I am culturing cancer cells and noticing strange growth in the media. To me it doesn't look like bacteria or yeast, and not consistent with images I've seen online of fungi in media. I removed the...

20 November 2023 4,431 0 View

How to learn more about SPSS and its Application?

I would like to learn more about SPSS and Its application especially in regards to data analysis. Please suggest me how I can learn more about it. Thank you so much.

11 August 2024 9,101 4 View

Has anyone applied Python in the field of textile engineering for data analysis, automation, or smart textiles?

I'm currently exploring the application of Python in textile engineering, specifically in areas like data analysis, process automation, and the development of smart textiles. I'm interested in...

10 August 2024 7,429 2 View

Where can I find the recent population of Indian cities (2020s) ?

Census data seems only to reach the year 2011, but there might be estimates somewhere that I cannot find? I am looking not only for the largest cities but also towns etc. Thanks!

10 August 2024 857 4 View

What should Berlin do as a city to become as impactful as London and Paris in World Football?

Please go through my Abstract. I can also share a proposed Thesis Outline.

04 August 2024 2,077 0 View

I need the datasets of Microgrid for system identification?

Hi I am working on data driven model of the microgrid, for that, i need the reliable datasets for the identification of MG data driven Model. Thanks

02 August 2024 5,748 4 View

Do you think can be any diamond bearing rocks in Eastern part of Iran near to Birjand city?

I want to know more about diamond ore deposits in Iran.

02 August 2024 7,399 0 View

Is there any novel idea to prevent mastitis in dairy cows?

herbal topical spray like any feed modification any immune booster to resist infection

31 July 2024 4,423 2 View

Posthoc test lettering in JAMOVI?

Does anyone know of a module for the JAMOVI software that is capable of generating mean separations using the classic letters based on post hoc results (e.g., Tukey test)? If, as I believe, such...

31 July 2024 3,333 4 View

How to back transform the results generated from analyses using log transformed with In(X+1) data?

I am conducting my analysis using SPSS. I log transformed my data using In(X+1) as my data contain zero values. However, when I want to back transform the regression coefficients generated from my...

31 July 2024 7,860 3 View

Are you interested in contributing a book chapter on biomaterials in Orthopaedics?

I am editing a book for Springer Nature on recent advancements and future trends in biomaterials for orthopedic and trauma applications, with a publication date slated for early next year. If you...

29 July 2024 5,015 9 View